Jul 13 2022 09:20 AM
I need help with embedding the COUNTIF function along with the COUNTIFS function. I have two different criteria that I need to count and add together in the first range and then apply a third criteria from another range to it. I keep getting the error that I do not have enough criteria to use this function.
=COUNTIFS(COUNTIF(range1, "criteria1")+COUNTIF(range1, "criteria2")), range2, "criteria3")
Jul 13 2022 09:24 AM
Jul 13 2022 09:32 AM
Solution=SUM(COUNTIFS(D4:D23,{"A";"B"},E4:E23,"option4"))
=SUMPRODUCT(((D4:D23="A")+(D4:D23="B"))*(E4:E23="option4"))
You can try these formulas.
Jul 13 2022 10:06 AM
Jul 13 2022 10:26 AM
=SUM(COUNTIFS(C4:C23,{"A";"B"},D4:D23, ">="&G2, D4:D23, "<=" &G3))
Your formula works perfectly in my sheet. In cells G2 and G3 i'd enter the formulas
=TODAY()
=TODAY()+30
to automatically update the range of dates.
Jul 13 2022 10:46 AM
Jul 13 2022 09:32 AM
Solution=SUM(COUNTIFS(D4:D23,{"A";"B"},E4:E23,"option4"))
=SUMPRODUCT(((D4:D23="A")+(D4:D23="B"))*(E4:E23="option4"))
You can try these formulas.