Summing Filtered Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok, I've filtered my spreadsheet using AutoFilter and
selecting one of the availble cell contents as a criteria.
Now that I've got a table that shows only the rows that
contain my selected filter qualification for that column,
I want to sum all the numbers in ONLY the filtered
adjacent column. How can I do this? Whenever I try to sum
that column, I get sum for entire UNFILTERED column, not
just the filtered items.
Thanks!
 
Use SUBTOTAL:

=SUBTOTAL(9,A1:A10)

where the first argument denotes the type of calcaluation
to perform:

1 AVERAGE
2 COUNT
3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP
 
Does anyone know how to COUNT the number of rows that are
a result of using the Autofilter? I have 2 columns. I'm
using SUBTOTAL(9,a1..a500) to sum the values in those
rows, but I have a second column that I need to just
count the # rows. ??? ANy help would be appreciated?
Thanks!
 
Back
Top