Solved

Sum only Data Filtered

Posted on 2014-04-06
3
173 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
[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
3 Comments
 
LVL 1

Accepted Solution

by:
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

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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

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.

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.

Join & Ask a Question