Sorry to hear it didn't work, hope that Roger's response fared better for
you

Maybe also see: http://www.decisionmodels.com/calcsecrets.htm
(Try CTRL+ALT+F9 to force full calculations ?)

And/or, take it out and try it in a new file with just the sheet: SCAR and
your sheet with the 75R x 15C formulas* in it (your current file probably
contains a few volcanic-loads of calcs for Excel to do <g)
*Use either your original array formula (which works), or the 2 alternative
SUMPRODUCT versions suggested
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"ttmannan" wrote in message
...

Max, I wish it would have worked, but unfortunately it didn't. Thanks
for your suggestion!