Formula Length (Excel 97)

[Ben]

I have the following array formula taht is generated via a macro, depending
on the selection in a worksheet...

{=SUM( IF( (ReportGroup="Demand") *
(((Group1="Mygroup")*(Group1="HisGroup")*(ProjNo="0100878")*(ProjDesc="Proje
cty")*(SectCode="EEA0")*(Site="Townsville"))), Date4 ) )}

....the problem I have is that the formula can be very large. It appears
that the formula gets truncated if it is above a certain length. Is there
any way around this?

TIA
Ben

 

[Frank Kabel]

Hi
the maximum lebgth is 1024 characters dor a formula. No way around this
maximum.