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!”
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