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.
|Check out our Excel Resources|
This should work
=COUNTIF(B1:B9,"West") + COUNTIF(B1:B9,"South") + COUNTIF(B1:B9,"North")
Hope this helps
would count everything and deduct the count of "west", in case any other values were added that weren't "west" (ie north-east or south-east etc) you wouldn't need to keep updating your countif formulae