Total Betwen dates

  • Thread starter Thread starter John D O'Connor
  • Start date Start date
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
 
Hi
one way:
=SUMIF(A1:A52,"<=" & datecell,B1:B52)
replace datecell with a cell reference to a given date
 
Back
Top