| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Count if criteria is part of list
Want to be able to count all value in particular range that have a
value that appear in list of multiple values eg have spreadsheet all different types computers and what versions of o/s and service pack they are running eg Sheet 1 A B Windows XP Professional SP2 Dell Inc. Windows XP Professional SP2 Dell Inc. Windows 2000 Professional SP4 Compaq Windows 2000 Professional SP4 Dell Inc. Windows 2000 Professional SP4 Dell Inc. Windows 98 sr2 IBM Windows XP Professional SP2 Dell Inc. Windows XP Professional SP2 Dell Inc. Windows 2000 Server SP4 Dell Inc. Windows 2003 Standard Server SP1 Dell Inc. SCO Unix 5.0.6 Compaq Sheet 2 Windows XP Professional SP2 Windows 2000 Server SP4 Windows 2003 Standard Server SP1 SCO Unix 5.0.6 What i need to count is how many machines are (Win XP, Win 2000 Server, Win 2003 Server ) etc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count unique with mulitple criteria | Excel Worksheet Functions | |||
| Count Unique Values with Multiple Criteria | Excel Worksheet Functions | |||
| Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria | Excel Worksheet Functions | |||
| How to count number of occurences in an autofilter list | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Threaded Mode
