ssblue
asked on
Excel countifs formula
Why is this not working??
I need to count the cell that contain "N/A" "2" "3" "4" "5" in column H3:H50
="Total Scheduled = "&COUNTIFS(H3:H50,"N/A", [H3:H50,"2"], [H3:H50,"3"], [H3:H50,"4"], [H3:H50,"5"])
I need to count the cell that contain "N/A" "2" "3" "4" "5" in column H3:H50
="Total Scheduled = "&COUNTIFS(H3:H50,"N/A", [H3:H50,"2"], [H3:H50,"3"], [H3:H50,"4"], [H3:H50,"5"])
ASKER
That doesn't work - I get zero and I should be getting 24
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
Late but worth, shorter one:
="Total Scheduled = "&SUM(COUNTIFS(H3:H50,{"N/A","2","3","4","5"}))
ASKER
Thanks, as always!
You're Welcome :)
="Total Scheduled = "&COUNTIFS(H3:H50,"N/A", H3:H50,"2", H3:H50,"3", H3:H50,"4", H3:H50,"5")