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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
Autonumber field in Excel that behaves the same as Access 0
SUMIF between 2 dates 1
SUMIF with criteria "<>" & "=" 4
Multiple Columns in Sum Range using SUMIFS 1
How can I define date range criteria in SUMIF formula? 1
sum columns only if date 5
VLOOKUP or SUMIF for Multiple Criteria 2

Top