You'll need to post your SUMIF formula for us to see the criteris. It sounds
like your criteria is inadvertently including the values in the subtotal rows.

Example:
=SUMIF(A1:A100,"<Harold",B1:B100)


***********
Regards,
Ron

XL2002, WinXP


"Graeme" wrote:

I'm trying to use a SUMIF function on a column that includes SUBTOTAL
functions. The SUMIF seems to include the SUBTOTAL even though it doesn't
match the criteria. Why? How can I can exclude the SUBTOTALs from the SUMIF?

TIA, Graeme