Total Betwen dates

J

John D O'Connor

I have a range of dates (week ending actually) in column A

In column B opposite each date is Total Sales for that week

I want to tot YTD Sales baed on What week we are currently in.

I'm thinking a formula that will add all Weeks (date) that are less than a
give, or typed in date.

Can anyone give me the formula?

Thanks

John
 
F

Frank Kabel

Hi
one way:
=SUMIF(A1:A52,"<=" & datecell,B1:B52)
replace datecell with a cell reference to a given date
 
Top