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

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