Performing a function on visible cells only in a range

G

Guest

Is there a way to perform a function (like =sum) on a range but only include
the cells that are visible?
 
P

Peo Sjoblom

From Excel 2033 onwards you can use the SUBTOTAL function, it is clearly
explained in help. In previous versions at least down to 97 you can use
SUBTOTAL when you filter rows but not hide them, from 2003 you can use it on
hidden rows as well
 

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

Formula only for visible Cells 1
sum visible 1
Sum If Visible 10
Conditional Formating in Excel 5
Excel VBA 1
Sum visible cells only 8
Paste to Visible Cells only 1
Using VBA to select a range within a range. 3

Top