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?

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