I create files using SAS, outputting to an HTM file, which opens up
easily in Excel. If I drag the cursor over a few cells I do not get
the 'sum=....' note at the bottom, which happens with a regular XLS
sheet.

If I use the sum function, 'sum(b2:b4)', I'll get a result of 0, but if
I enter '=b2+b3+b4' I get the correct number.

Anyone know of what might be causing this and how to correct?

Thanks for any help.