• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

Sum only Data Filtered

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
Bright01
Asked:
Bright01
1 Solution
 
JoseBarrosoCommented:
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
 
Bright01Author Commented:
Thank you!  Worked well.

B.
0
 
Naresh PatelTraderCommented:
I guess  =SUBTOTAL(109,your range)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now