Multiple Countifs

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.


Answers

  • 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))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!