Total Betwen dates

[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

 

[Frank Kabel]

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

 

[John D O'Connor]

Thanks, Frank and also for the rename worksheet with date format

Rgds

John

 

[Frank Kabel]

Hi John
you're welcome