Sum of Visible Cells

[JE McGimpsey]

Check out SUBTOTAL() in XL Help.

 

[Frank Kabel]

Hi
=SUBTOTAL(9,A1:A100)

 

[T Martin]

I have an excel spreadsheet and I filter some of the records. I would like
to know if there is some formula that would give me a sum of visible
records?

thanks

T Martin

 

[T Martin]

Perfect. Thanks

Hi
=SUBTOTAL(9,A1:A100)