Difficult to exactly understand how you have the various tables- from the
sample you gave I presume the months are in numeric format- you could do this
1 Have a cell somewhere with the month up to number you want say in c2
2 Then beside every line have an If statement e.g =IF(B4<=$C$2,"OK","Next
period") to determine if that month number is in range
The a sumif to add all numbers that have OK accross from them e.g
=SUMIF(A4:A10,A11,C4:C8)
where Col A is where ae:a10 is where the If formula is- A11 has OK in text
format & C4:C8 is the nymber range

You can then just directly link the total to you summary sheet- by changeing
c2 your YTD will also change

--
HTH

"Nena G" wrote:

I am using the below function in excel to get a ytd total for items that I
have on a report and it is not working. How do you get YTD totals to work
when you need to be able to select the period number and have the formula sum
the columns for selected rows, the data that I need to use for each YTD
column exists on a separate tab in the workbook (i.e. one tab called TOTAL
DC& HR1, one tab called SC, etc...). I need to sum up their individual
periods based on the current period (i.e. if its period 4 then I need to sum
up periods 1-4 for each tab on this one sheet). Is there a way to do this
with out creating a running YTD tab for each by period tab?
=SUM(OFFSET(VLOOKUP($B6,'TOTAL DC &
HR1'!$B3:$Q3,$C$2+1,FALSE),0,0,1,MONTH($C$1-1)))

My data Is as follows

A B C D E
1 Total Total XHR SC
6 Not used Sales $600 $600 $231
7 Cartons 125 125 58
8 Shipped 358 358 85