Thread: Why can't I use the MONTH function within the SUMIFS statement?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
djhunt77 djhunt77 is offline
external usenet poster
  
Posts: 2
Default Why can't I use the MONTH function within the SUMIFS statement?
I have a Detail worksheet with three named ranges: Category, DateOfService
and Amount.

I have a Summary worksheet where I am trying to summaries the amounts by
Category (represented by the rows) and Month (represented by the columns).

Why do I get an error when I try to use this formula on the Summary sheet?

=SUMIFS(Amount,Category,A2,Month(DateOfService),1)

where A2 is the first row in the summary data.
Reply With QuoteReply With Quote