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:

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?