Adding the # of rows, not the contents...

[jacob farino]

On my sub-totals row, most of the columns are just added together for a sum
figure. However, can I have a particular column tally how many columns it is
counting? Specifically, I have a column for customer's names. I just want
the subtotal bar to display how many customers there are in the column above
it.

Thanks!

 

[Charlie O'Neill]

Jacob,

Try changing the 'sum' function in the subtotal bar to 'count'. Or add a
formula, for example if the customers are listed in Column A, then in any
empty cell enter the formula =count(A:A)

Charlie O'Neill

 

[jacob farino]

Problem with this one:

It will count only numerically-filled cells, it won't count the borrower's
names and give me a total.

 

[Ragdyer]

If you're using <Data> <Subtotals>,
There are choices in the dialog box to add a "count" total row above or
below the "sum" total row, where you can also choose in which column to
place the actual "count".

If you're manually creating subtotals with the subtotals formula, you could
add an additional subtotals formula that will count instead of total.

=SUBTOTAL(2,A2:A100)

 

[icestationzbra]

provided i am not missing the big picture somewhere, i think 'counta
will show a count of all populated rows in a column

 

[Jim May]

Example (only)..
In Cell A111 enter:
=subtotal(3,A2:A100)