Summing between two dates

D

Don

I have a list of sales data. Column A is a list of dates (workdays). Column
B is the corresponding sales for those days.

I need to write a formula that will give me the sum of prior years sales
from the first of that year to the current date of that year. For instance,
today's date is 7/29/08. I want a formula that will sum the sales between
1/1/07 through 7/29/07. Any help would be appreciated.
 
P

Pete_UK

Try this:

=SUMPRODUCT((A1:A100>=DATE(YEAR(TODAY())-1,1,1))*(A1:A100<=DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())))*B1:B100)

Hope this helps.

Pete
 
D

Don

Thank you.
--
Don Rountree


Pete_UK said:
Try this:

=SUMPRODUCT((A1:A100>=DATE(YEAR(TODAY())-1,1,1))*(A1:A100<=DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())))*B1:B100)

Hope this helps.

Pete
Click to expand...
 
P

Pete_UK

You're welcome, Don. I see that Max and I came up wth virtually the
same solution.

Pete
 

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

SUMIF between date range 0
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
SUMIF between 2 dates 1
Need some PWA help 0
Calendar Logic: Recurring Dates 3
How to use/create code in MS Word to calculate age? 0
Pivot Table showing wrong data 1
Countif or other formula needed for multiple data/critera results 3

Top