SUMIF with criteria a date range

V

Vig

How do I sum a column selecting data associated with a date in another
column? For example any transaction associated with a March date.
 
J

Jason Morin

Sum A1:A28 where dates fall in March in B1:B28 (for
example):

=SUMPRODUCT((TEXT(B1:B28,"mmm")="Mar")*A1:A28)

HTH
Jason
Atlanta, GA
 
D

Domenic

Assuming that your dates are in Column A and their corresponding values
in Column B...

=SUMPRODUCT(--(MONTH(A1:A10)=3),--(YEAR(A1:A10)=2004),B1:B10)

Hope this helps!
 
Top