It's actually pulling sales from last year. I'm using it to compare how we have done this year to the same time last year, so I only want up until the current week we are in. There would be 52 weeks worth of sales. "Pete_UK" wrote: Why can't you just do: =SUM(C3:BB3) ? Hope this helps. Pete On Jan 10, 10:36 am, Anne <A...@discussions.microsoft.com

=SUMIF(C1:BB1,"<="&'Weekly Summary'!$G$1,C3:BB3) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Anne" <Anne@discussions.microsoft.com> wrote in message news:30A7BB3C-E399-4D9E-9D74-00161E68A384@microsoft.com... Every week I have to calculate year-to-date sales, so wanted to do a sumif statement at the end. I have the current

You can use 1 to 52 in the cells in the header, while you format the cells to look like wk01, ... Use a custom notation. Then, you can calculate totals using numbers. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Anne" wrote: Every week I have to calculate year-to-date sales, so wanted to do a sumif statement at the end. I have the current week number listed