View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default 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