I guess what the OP wants but I can't do it (maybe it cannot be done):
Using ={1;1;1;1;1;1;1;1;1;1;1;1} as source formula of a Name returns an
array of 12 element (constant 1s). He want the element automatically change
value according to a certain month value, e.g. if this value is 6, then the
returned array should be ={1;1;1;1;1;1;0;0;0;0;0;0}

Stefi


€žMike H€� ezt Ã*rta:

Hi,

It's not very clear what you actually want to do but consider SUMPRODUCT. A
formula such as the one below may help in which if the month in A1 to A10 is
prior to August (<=7) then column B is summed.

=SUMPRODUCT((MONTH(A1:A10)<=7)*(B1:B10))

Mike

"KC Excel Qns" wrote:

Can someone please help me out.

I would like to use a Name to contain 12 values, either 0s or 1s.

If I want to compute YTD June 2009, this name will contain
1,1,1,1,1,1,0,0,0,0,0,0 and multiplied by a row of 12 months data. I
am thinking of using array.

Likewise, if I want to compute Rest of Year 2009, this name will
contain 0,0,0,0,0,0,1,1,1,1,1,1 multiplied by a row of 12 months
data.

Regards,