Get instant live expert help on I need help with excel countifs not blank

In need a formula IF column D is not blank AND column G OR column I OR column J is blank THEN "Pending" IF column D is not blank AND column G OR column I OR column J is not blank THEN "Closed" I have tried COUNTIFS, IFS, and can't get this to work. I don't know what I am missing. Each column is a DATE as well. I was thinking If DATEVALUE like whatever the date is then yada yada, but I can't get this rationale to work in excel AT ALL. I'm at a lost.

I'm trying to use a countifs formula and it's just not working. Ive tried: =COUNTIFS(H3761:27790, M3761, G3761:27790, "MG") =COUNTIFS(H3761:27790,"*"&M3761&"*", G3761:27790, "*"&$R$1&"*") =COUNTIFS(H3761:27790,"*"&M3761&"*", G3761:27790, "*"&MG&"*")

Hey I would like to use Sumifs or Countifs function in my excel but I have faced with #VALUE error even it's a simple function. =COUNTIFS($I:$J;"1";A:A;"ST-0009") does not work when the I&J Colums includes with 1 and A Coloum ST-0009 Text. it's not counting.how many 1 I have for ST-0009

Trying to modify my formula from: =COUNTIFS(Member,$B2,SubmissionDate,">="&C$1,SubmissionDate,"<"&(C$1+7)) To: =COUNTIFS(Member,$B2,SubmissionDate,">="&C$1,SubmissionDate,"<"&(C$1+7),CoTDate,"<>"&"") Not working

Is there a way to simplify this formula? =COUNTIFS(_1,E2,_2,F2)+COUNTIFS(_1,E2,_3,F2)+COUNTIFS(_1,E2,_4,F2)+COUNTIFS(_1,E2,_5,F2)+COUNTIFS(_1,E2,_6,F2)+COUNTIFS(_1,E2,_7,F2)+COUNTIFS(_2,E2,_3,F2)+COUNTIFS(_2,E2,_4,F2)+COUNTIFS(_2,E2,_5,F2)+COUNTIFS(_2,E2,_6,F2)+COUNTIFS(_2,E2,_7,F2)+COUNTIFS(_3,E2,_4,F2)+COUNTIFS(_3,E2,_5,F2)+COUNTIFS(_3,E2,_6,F2)+COUNTIFS(_3,E2,_7,F2)+COUNTIFS(_4,E2,_5,F2)+COUNTIFS(_4,E2,_6,F2)+COUNTIFS(_4,E2,_7,F2)+COUNTIFS(_5,E2,_6,F2)+COUNTIFS(_5,E2,_7,F2)+COUNTIFS(_6,E2,_7,F2) The underscored numbers represent individual columns of data.