Hello, I'm using:
=SUM(COUNTIFS($P:$P, "Program Planning & Policy",$O:$O, {"AZ","CA","DC","IN","LA",
"ME","MI",
"NC","NY",
"PR","TX",
"VT","WA"}
,$S:$S, {"Reg.","IS"}))
To try an count some data, however it seem if I try to add the add the additional criteria to the last range of "IS" the formula no longer works.... If I'm just counting for "Reg." or "IS" individually it counts correctly....
Why can't I count the last range for 2 criteria... is there an alternate work around apart from doing two COUNTIFS ala:
=SUM(COUNTIFS($P:$P, "Program Planning & Policy",$S:$S, "Reg.",$O:$O, {"AZ","CA","DC","IN","LA",
"ME","MI",
"NC","NY",
"PR","TX",
"VT","WA"}
),COUNTIFS
($P:$P, "Program Planning & Policy",$S:$S, "IS",$O:$O, {"AZ","CA","DC","IN","LA",
"ME","MI",
"NC","NY",
"PR","TX",
"VT","WA"}
))
Dummy.xlsx