View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TPDigg TPDigg is offline
external usenet poster
 
Posts: 10
Default Combining subtotal and sumif functions

I would like to combine the sumif function with filters and sum only the data
chosen in the filter. Subtotal (109,xxx) would ignore the hidden data but I
am having trouble combining the functions sumif & subtotal. Help much
appreciated.