View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Graeme Graeme is offline
external usenet poster
 
Posts: 59
Default Excluding subtotals from SUMIF function

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