Sum Visible Cells Only

[blharty12]

Hi there,I've done a search of the forum and didn't see this question anywhere. I have a spreadsheet of data with some hidden rows. I need to sum only the visible cells. Is there a quick formula to do this?Thank you for your help!

 

[Jonmo1]

Try the subtotal function

=SUBTOTAL(109,A1:A100)

 

[Domenic]

You can use the SUBTOTAL function...

=SUBTOTAL(109, A2:A100)

The SUBTOTAL function also has other function arguments, which means that it can also return a count, average, etc. Have a look at the help file for additional information.

Hope this helps!

 

[blharty12]

You all are phenomenal! Thank you! This worked!

 

[Jonmo1]

Glad to help, thanks for the feedback.