# 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 counting.how 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