offset and Sum function
Hello,
With Sandy's formula I could not get correct results.
FastExcel showed in my test environment for:
Roger 27.04 msec
Sridhar 27.39 msec
David 2113.87 msec
Volatile means recalculation with each F9 even if input does not
change (should be avoided).
Regards,
Bernd
|