How do i total a specific sum, using the filter?

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

Guest

on my spreadsheet i have several entries from various companies. I am using a
filter to isolate certain companies and their amounts at any given time. How
can I sum total only the amounts selected? thank you
 
Use the SUBTOTAL function.

=SUBTOTAL(9,B:B) which includes filtered and hidden values.

Or in 2003 version

=SUBTOTAL(109,A:A) which ignores hidden values.


Gord Dibben MS Excel MVP


on my spreadsheet i have several entries from various companies. I am using a
filter to isolate certain companies and their amounts at any given time. How
can I sum total only the amounts selected? thank you
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top