Asked by: edward5-ga
List Price: $20.00
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?
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
|There are no comments at this time.|
If you feel that you have found inappropriate content, please let us know by emailing us at email@example.com with the question ID listed above. Thank you.
|Search Google Answers for|