?
Solved

Sum only Data Filtered

Posted on 2014-04-06
3
Medium Priority
?
204 Views
Last Modified: 2014-04-06
EE Pros,

Question; what formula (e.g. Sum) do I use if I want to only see the sum values for the records that are selected when I use filtering?  If I have 100 records that = $100,000, and apply a certain filter on a column, I want only the value of the subset of records that are displayed.

Thank you,

b.
0
Comment
Question by:Bright01
3 Comments
 
LVL 1

Accepted Solution

by:
JoseBarroso earned 1200 total points
ID: 39981940
Hi,

Istead of using the formula "=Sum (a,b)" try use this "=SUBTOTAL (9,a,b)"
(the 9 means "sum" in the SUBTOTAL function)

Hope this help
0
 

Author Closing Comment

by:Bright01
ID: 39981989
Thank you!  Worked well.

B.
0
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39982023
I guess  =SUBTOTAL(109,your range)
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question