2003 Compatible Formula

[ExcelRoy]

Hi Guys,

I have a problem. I have devised (with your help) the following formula, but it appears to not work on excel 2003

Any ideas what i need to change in order for it to work on 2003?

=IF(ISNUMBER(MATCH("*Additions*",H16:H216,0)),SUM(INDEX(X16:X216,MATCH("*Additions*",H16:H216,0)):X216),0)

and

=IF(AND(U219=0,U221=0),"",U221)

Thanks

 

[VoG]

No reason why those would not work. What error, if any?

 

[ExcelRoy]

The "Addition" part of the formula appears not to calculate?

Very strange. I will re-check at work tomorrow

Thanks VoG

 

[VoG]

Tools > Options > Calculation tab. Make sure that calculation is set to Automatic.