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