Summing Filtered Rows

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

 

[Harald Staff]

=SUBTOTAL(9,A2:A1000)

HTH. Best wishes Harald

 

[Jason Morin]

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

 

[Carol]

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!

 

[Frank Kabel]

Hi
try
=SUBTOTAL(3,B1:B500)