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

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