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!!