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

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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.
Solved by A. L. in 15 mins
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&"*")
Solved by S. H. in 26 mins
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 many 1 I have for ST-0009
Solved by X. W. in 24 mins
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
Solved by T. U. in 16 mins
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.
Solved by Z. E. in 27 mins