sum visible cells

  • Thread starter Thread starter pejman
  • Start date Start date
Dear friends
do you know how can i sum just visible cells (it sum hiden cells too)?
Click to expand...

You can obviously select the cells to include individually, but there
must be abetter way than that.
 
Are the hidden cells hidden because of a filter or have you specifically
hidden them ?
If they are hidden through a filter, you can use the Subtotal function
instead of the Sum because SubTotal does not include cells hidden by a filter.
=Subtotal(9,Cell1:Cell2)
 
Depending on your version of XL, you might like to try this:

=SUBTOTAL(109,A1:A100)

The 109 ignores rows hidden by filters and rows which are manually
hidden.

Hope this helps.

Pete
 
Specifically this works from Excel 2003 onwards, not in 2000 or below (not
sure about 2002, never had my hands on a copy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum If Visible 10
Numbers showing Up Centered in Cell ? 1
sum visible 1
Excel formula, sum the value cell and if empty cell left blank 0
Excel How to add numbers in same cell? 2
Help Writing a SUM Formula 5
VBA to hide a row in different worksheet 2
Getting Text data using the Data - Subtotal feature 1

Back
Top