Hi

i'm not really sure what you're trying to achieve here ... if MONTH is a
range name it is not a good one ... suggest changing it for a start.

Secondly, i think an index, match formula might work best for the first
formula
=INDEX(Sheet1!A4:E7,MATCH(B1,Sheet1!A4:A7,0),MATCH (A1,Sheet1!A4:E4,0))
where A1 holds the month and B1 holds the customer number

and the following formula for the second
=SUM(OFFSET(Sheet1!A4,MATCH(B1,Sheet1!A5:A7,0),1,1 ,MATCH(A1,Sheet1!B4:E4,0)))
where A1 holds the month and B1 holds the customer number

Hope this helps
Cheers
JulieD


"X" wrote in message
...
I am trying to Sum a Year to date range based on a month reference. Ideas?

Sheet 1:

Jan05 Feb05 Mar05
12345 12 34 56
67890 78 90 12
23456 34 56 78

Sheet 2:
Column 1 Column2
12345 =SUMIF(CustNum,CustNum2,INDIRECT(Month))

Column3 (Not working)
=SUMIF(CustNum,CustNum2,INDIRECT(CONCATENATE(Month ,"Total")))