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
|
Similar Threads
