SUM Function - Adding filtered data

[summerguy]

Hi - can someone please advise how I can add filtered data in a column without adding numbers that have been filtered out?

eg SUM(A5:A121) but exclude the values that have been filtered out.

Thx

 

[Diffy]

If you just highligh the data, the sum in the bottom right will only be the visible cells.

 

[summerguy]

Thanks Diffy - is there a formula to add these in a separate cell as is shown on the bottom right?

 

[pgc01]

Hi summerguy

Use:

=SUBTOTAL(9,A5:A121)

Hope this helps
PGC

 

[summerguy]

Thanks - much appreciated.