Could anybody tell me how to add values based on dates.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to get the sum of a particular month E.G. 1 Jan 07 to 31 Jan 07 from 6
months data?
 
Assuming there is only January for ONE year then try:

=SUMPRODUCT(--(MONTH(A1:A100)=1)*(B1:B100))

Where A1:A100 are your dates (cells formatted as DATE) and B1:B100 is the
data to be summated.

If there are multiple years:

=SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2007)*(B1:B100))


HTH
 
You must log in or register to reply here.

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

Date Function 5
SUMIF ?! .... not quite enough.... 4
How to determine the value? 1
Count how many persons in a month using a date 2
How do I sum a column with only a certain date range? 14
how to create a formula with expiry condition 2
How to use index match for multi lookups? 1
Date Function 1

Back
Top