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
|