Formula Length (Excel 97)

  • Thread starter Thread starter Ben
  • Start date Start date
B

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
 
Back
Top