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

J

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

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
 
J

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.
 
R

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)
 
I

icestationzbra

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