Subtotaling count and sum

H

Hal Plimpton

Can't find steps to subtotal a list showing both count and sum of
columns. Example, totaling a dollar column and also indicating the
number of transactions. I can calc one or the other, but not both. I'm
sure it can be done, just don't know how.

Any suggestions appreciated....Hal
 
D

Dave Peterson

Have a look at help for =subtotal().

It has a bunch of options for the first parameter. One will count, one will
sum, one will countA and about 8 more!

=subtotal(2,a1:a10) will count the number of numbers
=subtotal(9,a1:a10) will sum the values

And =subtotal() will limit itself to the visible cells if you've applied
data|filter|autofilter (which is nice).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013: AutoFilter and SUM() 1
Getting Text data using the Data - Subtotal feature 1
Subtotal - Additional Formulas based on Subtotal range(s) 6
Using subtotals in Pivot table formulas 0
Counting Subtotaled Items 0
Displaying a count as a percentage within subtotals in a pivot tab 1
list items from one table in another table based on value in first table 2
Macro Pause to Select range then Subtotal 0

Top