View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zakhary Zakhary is offline
external usenet poster
 
Posts: 19
Default Counting the number of occurrences...

If I have a range (B3:B27) that contains number values between 0 and 5, and I
want to count the number of times each of those values occurs in that range,
what formula can I use...

In cell B28, I want the total number of instances that "5" occurs in the
range (B3:B27); In cell B29, I want the total number of instabnces that "4"
occurs in the range (B3:B27); and so on.

What formlua performs this task?

--
Thanks,
Zakhary