Use the SUBTOTAL function.

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

--
Biff
Microsoft Excel MVP


"angie" wrote in message
...
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?