I have a spreadsheet that I use to track weekly performance. I have a cell
established for the given work week. I enter all of my weekly data on Monday
each week for the previous week. I want a sum total of only the data up to
that given week. How can I formulate to make it only add the cells up to the
current week?
--
keith jones

Hi,

You should show us a sample of the data with an explanation of the desired
results.

Without that, maybe you should look at SUMIF or SUMIFS (2007) or OFFSET or
INDEX combined with other funtions or maybe its as simple as SUM? Hard to
tell with the description provided.

Is the data being inserted at the top of a range, is the date being added to
the bottom of a range, how do you know what weeks the data belongs to? If
you add new data each week how could you be doing anything but totalling to
the current week? You can't total data you don't have yet? I'm confused.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"kajones" wrote:

I have a spreadsheet that I use to track weekly performance. I have a cell
established for the given work week. I enter all of my weekly data on Monday
each week for the previous week. I want a sum total of only the data up to
that given week. How can I formulate to make it only add the cells up to the
current week?
--
keith jones

Thanks for the reply and sorry for the confusion. I can get the YTD total
for this year. The problem lies in the fact that I create a weekly summary
of our performance, and I want to show where we were during this week last
year. That is the column that I need to show the sum for the weeks to date.
In my report, I am reporting the number of terminations that I have YTD this
year vs. last year. I have the week numbers in column A and the terms in
column P. As I said earlier, this year is not a problem. The problem is
getting the terms for last year, only through, as an example week number 3
(column A) Does this help?
--
keith jones


"Shane Devenshire" wrote:

Hi,

You should show us a sample of the data with an explanation of the desired
results.

Without that, maybe you should look at SUMIF or SUMIFS (2007) or OFFSET or
INDEX combined with other funtions or maybe its as simple as SUM? Hard to
tell with the description provided.

Is the data being inserted at the top of a range, is the date being added to
the bottom of a range, how do you know what weeks the data belongs to? If
you add new data each week how could you be doing anything but totalling to
the current week? You can't total data you don't have yet? I'm confused.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"kajones" wrote:

I have a spreadsheet that I use to track weekly performance. I have a cell
established for the given work week. I enter all of my weekly data on Monday
each week for the previous week. I want a sum total of only the data up to
that given week. How can I formulate to make it only add the cells up to the
current week?
--
keith jones