Get instant live expert help on 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

I have a formula that isn't quite working. Need to look in column "B" for RIGHT, LEFT, RT, LT, R, L & return a "R" or "L" in a new column. If not present, then the cell = blank. An example would be: SQUAMOUS CELL CARCINOMA SKIN/ L EAR AND EXTRN AURIC CANAL It should return a value of "L". Left cannot be a wildcard because the word "CLEFT" can also be in column B. Here is the formula i am using - but it is returning all "R"s regardless. =IF(COUNTIFS(B1609,"Right")>0,"R",IF(COUNTIFS(B1609,"*RT*")>0,"R",IF(COUNTIFS(B1609,"Left")>0,"L",IF(COUNTIFS(B1609,"LT")>0,"L",IF(COUNTIFS(B1609,"*R *")>0,"R",IF(COUNTIFS(B1609,"*L *")>0,"L "," "))))))
Solved by C. J. in 27 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
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
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
Countifs formula is not working. It keep receiving an name or value error.
Solved by F. F. in 13 mins