Forum Discussion
countifs more than 2 criteria
Hello, I am trying to count the type of management type using the below table using the countifs function but everytime I use more than 2 criteria I got a 0 value. I used the following =countifs...
Hi Vitor,
As i remember COUNTIFS allows up to 256 criterias. In your latest condition use "=2009"
Dear Sergei,
Many thanks for your reply.
Still does not work. Each criterion is coming from a different column so column A will be the year range, column B borough, and column C management type. When I type the function countifs
the syntax I am using is:
=countifs(column c range,"=Trust", column b range,="Adur", column a range, "=2009")
And I get a zero value...
Hi Vitor,
Please see file attached. I used
=COUNTIFS(C2:C40,"Trust*",B2:B40,"Adur*",A2:A40,"=2009")
Trust*, Adur* since there are spaces at the end of strings, not sure that's in your file or they were added when i copy/pasted from screen.