View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kane Kane is offline
external usenet poster
 
Posts: 14
Default Modify SUMIF to find data range in addition to value

I am using Excel 2007. How can I modify sumif formula to sum only cells that
meet the sumif and date range critiera?

=SUMIF('1563'!$F$9:$G$55202,"groceries",'1563'!$D$ 9:$D$55202)

-btw, it is near impossible to search the discussion group right now to find
recent postings. And the nofication of replies is not working as well in the
discussion groups.