software

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

I have one more piece of info I have found. When I click on the function
button to look at how the cell is calculating for these cells, the
calculation is different. The cell that is counting correctly (count = 0)
shows quot;0quot; in the cell it is counting. The one that is counting incorrectly
(count = 1) shows quot;quot; in the cell it is counting. When you click in the cells
being counted, they both have nothing in them and are formatted the same
(number w/no decimal places).

quot;Sunryzzquot; wrote:

gt; I have two spreadsheets with different data which I am subtotaling the same
gt; way; a count of the number of entries in a certain column at each change in
gt; the entry in the code column. In both cases, the formula is the same -
gt; subtotal(3,cell:cell). However, in one spreadsheet when I have a code that
gt; has no entries in the counted column, I get a count of 0 and the other
gt; spreadsheet gives me a count of 1. There is nothing in the column being
gt; counted in either case and I can't figure out why they are different. Does
gt; anyone have any suggestions of what I might be doing wrong?
gt; Thanks!!

Oh, I bet there is something in that worksheet that gives you a 1.

Maybe it's as simple as a space character.

Maybe it's a formula that returns quot;quot;

(or used to be a formula that returned quot;quot; and was converted to values.)

I'd show all the data.
Select the first cell at the top of the column and do:
End|down arrow.

If excel stops on a cell (not in row 65536), hit the delete key to clear the
contents.

Sunryzz wrote:
gt;
gt; I have two spreadsheets with different data which I am subtotaling the same
gt; way; a count of the number of entries in a certain column at each change in
gt; the entry in the code column. In both cases, the formula is the same -
gt; subtotal(3,cell:cell). However, in one spreadsheet when I have a code that
gt; has no entries in the counted column, I get a count of 0 and the other
gt; spreadsheet gives me a count of 1. There is nothing in the column being
gt; counted in either case and I can't figure out why they are different. Does
gt; anyone have any suggestions of what I might be doing wrong?
gt; Thanks!!

--

Dave Peterson

Thanks, that did the trick.

quot;Sunryzzquot; wrote:

gt; I have one more piece of info I have found. When I click on the function
gt; button to look at how the cell is calculating for these cells, the
gt; calculation is different. The cell that is counting correctly (count = 0)
gt; shows quot;0quot; in the cell it is counting. The one that is counting incorrectly
gt; (count = 1) shows quot;quot; in the cell it is counting. When you click in the cells
gt; being counted, they both have nothing in them and are formatted the same
gt; (number w/no decimal places).
gt;
gt; quot;Sunryzzquot; wrote:
gt;
gt; gt; I have two spreadsheets with different data which I am subtotaling the same
gt; gt; way; a count of the number of entries in a certain column at each change in
gt; gt; the entry in the code column. In both cases, the formula is the same -
gt; gt; subtotal(3,cell:cell). However, in one spreadsheet when I have a code that
gt; gt; has no entries in the counted column, I get a count of 0 and the other
gt; gt; spreadsheet gives me a count of 1. There is nothing in the column being
gt; gt; counted in either case and I can't figure out why they are different. Does
gt; gt; anyone have any suggestions of what I might be doing wrong?
gt; gt; Thanks!!