Thread: Sumif for Date Range
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Sumif for Date Range
One way:

=SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2007),C1:C100)

In article ,
Raza wrote:

My sheet has more than one January, how do I sum January 07 only?
Reply With QuoteReply With Quote