Forum Discussion
Vitor Leone
Jul 26, 2017Copper Contributor
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...
Logaraj Sekar
Jul 26, 2017Steel Contributor
Hi Vitor César,
There is no problem. Select Correct range (either specified cells or entire column) and apply
=COUNTIFS(C:C,"Trust",B:B,"Adur",A:A,"2009")
I've taken your data as A,B,C Columns respectively.