Compound COUNTIF statements
Posted by Demetrius Tickles on December 27, 2001 4:19 PM
I am trying to get the COUNTIF function to look at a column and look at the different text values in it then give me a total for all of them.
Sample of the column B
If I wanted to get a count on the total number of items with the name "West", I could use the COUNTIF function as follows and get the number 3 returned:
The result should return the number 3.
If I wanted to count the other items (East, South and North) also, how can the COUNTIF statement be compounded to return the number 9 as that is the total number of them all?
Any help you could offer would be greatly appreciated.