| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count total values excluding some data
Hi,
I am trying to count number of values in a certain column but at the same time it should exclude some other values in the column from another sheet. For instance I want to what other internet connection the users used excluding Cable, DSL, T1 etc. =SUMPRODUCT(--(CrseEvalData!H6:H50<"Cable,DSL,T1"),--(CrseEvalData!H6:H50<"")) function does not work. It counts all the values in the column. What function can I use for my purpose? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sum number values, excluding data returned #N/A during Vloo | Excel Worksheet Functions | |||
| excel total days formula including weekends, excluding holidays | Excel Discussion (Misc queries) | |||
| Pivots: Grand total = Count not sum of data | Excel Discussion (Misc queries) | |||
| Excluding numbers in a total | Excel Discussion (Misc queries) | |||
| How do I use countif to count values excluding blank cells | Excel Worksheet Functions | |||
Threaded Mode
