Thread: count instance
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brad Brad is offline
external usenet poster
 
Posts: 846
Default count instance

Thanks for taking the time to read my question.

I have a list of computer models and I'd like to have totals at the bottom
of each kind using a formula.


A
1 Laptop
2 Desktop
3 Server
4 Laptop
5 Desktop
6 Desktop
7 Laptop

So my formula would look at column A rows 1 to 7

Total Laptops = 3 (calculated value, not static value)
Total Desktops = 3 (calculated value, not static value)
Total Servers = 1 (calculated value, not static value)

I was thinking of an array, but I'm not sure how to do that, or if it is the
correct approach.

Thanks again for your help,

Brad