Google Answers Logo
View Question
 
Q: Excell Spreadsheet ( Answered,   0 Comments )
Question  
Subject: Excell Spreadsheet
Category: Miscellaneous
Asked by: edward5-ga
List Price: $20.00
Posted: 05 Jan 2005 05:46 PST
Expires: 04 Feb 2005 05:46 PST
Question ID: 452295
An excell spreadsheet has been created to capture revenue.  The form
has a seperate column to indicate the week (1-4). The weekly column
has a sorter which will allow the individual to look at a specific
week or the entire month. Currently the total revenue is only showing
the aggregate of all of the information even if you select a certain
week because the cells are simply hidden.  My question is what formula
do I need for the TOTAL REVENUE as this column will change depending
on which week is selected?
Answer  
Subject: Re: Excell Spreadsheet
Answered By: hammer-ga on 05 Jan 2005 06:50 PST
 
Edward5,

The SUBTOTAL worksheet function operates only on visible cells. So, if
you are currently using something like this:
=SUM($B1:$B15)

... then you would use this instead:
=SUBTOTAL(9,$B1:$B15)

The first argument to SUBTOTAL is a number indicating what summary
function (like SUM, AVERAGE, etc) to perform. A complete list is
available in Excel Help for the SUBTOTAL worksheet function. The list
is also available at the following website.
Tech On The Net
http://www.techonthenet.com/excel/formulas/subtotal.htm

There is a nice explanation of how to use SUBTOTAL to do what you
describe at the following website:
Daily Dose of Excel
http://www.dicks-blog.com/archives/2004/09/08/accumulating-visible-cells/

Please let me know if you need any further explantion of the SUBTOTAL
function. Good luck with your Excel project!

- Hammer


Search strategy
----------------
excel total visible cells
Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy