sum function

A

angie

i want to sum only filtered records in my worksheet. is that possible?

with the sum function this does not work. could i use another function?
 
T

T. Valko

Use the SUBTOTAL function.

Look up SUBTOTAL in Excel Help to see all the variations that are possible.
 
M

Marcelo

check the help for the subtotal funcion

to sum filtered cells is =subotal(9,a2:a1000)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"angie" escreveu:
 
Top