| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal count not working
I have two spreadsheets with different data which I am subtotaling the same
way; a count of the number of entries in a certain column at each change in the entry in the code column. In both cases, the formula is the same - subtotal(3,cell:cell). However, in one spreadsheet when I have a code that has no entries in the counted column, I get a count of 0 and the other spreadsheet gives me a count of 1. There is nothing in the column being counted in either case and I can't figure out why they are different. Does anyone have any suggestions of what I might be doing wrong? Thanks!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count unique values among duplicates in a subtotal range | Excel Discussion (Misc queries) | |||
| how to sum and count in subtotal | Excel Discussion (Misc queries) | |||
| count rownumbers in loop | Excel Discussion (Misc queries) | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
| SUBTOTAL and then count with criteria | Excel Worksheet Functions | |||
Threaded Mode
