| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count nonblank cells with multiple criteria
I have a fairly large spread sheet that I usually filter or us a pivot table
to get what I need and then manually input into another workbook. What I need is to count the nonblank cells in column G (which consists of times in hh:mm:ss format) based on column A = KM06 and column C = 1 (both general format). I have tried using the sumproduct, sumif, if, and count. Thank You in advance, -- Daniel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
| I need to count while using multiple criteria | Excel Worksheet Functions | |||
| Multiple Criteria IF Nesting | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Threaded Mode
