After I put in a formula I always hit Enter, not (Ctrl + Shift + Enter), does
it make a differnce in Excel 2007?

"Billy Liddel" wrote:

=SUM(C2*2) works OK for me or =SUM(C2:C5*2) committed as an array (Ctrl +
Shift + Enter)

regards

"oldny" wrote:

I am working on a new spreedsheet and wanted to multiply the total of 22
columns by a constant. No mater what constant I put into the formula
=SUM(E53* ) Excel gives me the wrong answer. Now I have cleared contents in
every cell thinking it may be something left over but that did not help. I
have used two calculators and two human calculations and they come up with
the same answer which is different from the Excel answer. Has anyone else
experienced this problem?