Solved

# Sum only Data Filtered

Posted on 2014-04-06
173 Views
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
Question by:Bright01
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions

LVL 1

Accepted Solution

JoseBarroso earned 300 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

ID: 39981989
Thank you!  Worked well.

B.
0

LVL 8

Expert Comment

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

## Featured Post

Question has a verified solution.

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

### Suggested Solutions

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
###### Suggested Courses
Course of the Month3 days, 9 hours left to enroll

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

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