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

A

auntwanette

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
 
G

Gord Dibben

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
 

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

QBF & Query Malfunction 0
sum visible amounts 2
Custom views and formulas 2
Two Totals from the same column 2
Sumif using partial string 7
How To Rapidly Copy Formulas? 0
Images are pixelated when saving to PDF 0
How to ignore a column of numbers in Grand Total for rows 1

Top