Multiple Countifs

Drew Cooper

Attempting to create a count based on multiple conditions. Here is what I thought would be needed but its not working. I feel like I'm close and just need a little more help.

So in short, only count if all these are met.

Mike matthys

try this , your ) are in the wrong place

should be

countifs(...;...;...;...)

you had

countifs(...;...);...,...

you can see this at the colors of the ) of your second contains, it doesnt match the color of the opening ( of that contains, means something is closed of to soon

=countifs({WANAKA Range 3}, CONTAINS("No", @cell), {WANAKA Range 4}, CONTAINS("No", @cell), {WANAKA Range 1}, CONTAINS("Active", @cell), {WANAKA Range 1}, CONTAINS("Retired", @cell))