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,

Who is Participating?
JoseBarrosoConnect With a Mentor Commented:

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
Bright01Author Commented:
Thank you!  Worked well.

Naresh PatelTraderCommented:
I guess  =SUBTOTAL(109,your range)
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.

All Courses

From novice to tech pro — start learning today.