Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Always Open in New Instance | Excel Discussion (Misc queries) | |||
Looking for a function that will count the first instance of a | Excel Worksheet Functions | |||
First Instance | Excel Discussion (Misc queries) | |||
How do I get rid of a 2nd instance (xls:2)? | Excel Discussion (Misc queries) | |||
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria | Excel Worksheet Functions |