View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WildWill WildWill is offline
external usenet poster
 
Posts: 64
Default COUNT IF in array

Hi

I have the following data:

A B
22 Cat
29 Bat
22 Tax
24 Bat
22 Cat

I want to calculate the total number (COUNT) of the occurences of "Cat" in
Column B, where Column A's value is "22". I.e. the answer to the above
example will be 2.