Excel
 

my excel program is not adding up the formulas (eg =SUM(A1:A2)) it is not
adding it up, if anyone could reply it would be helpful thank you

Excel
 

"help plz" wrote:
my excel program is not adding up the formulas (eg =SUM(A1:A2)) it is not
adding it up, if anyone could reply it would be helpful thank you

It sounds like the calc mode's inadvertently set to Manual. Press F9 key,
does it now compute properly? To check/change calc mode, click Tools
Options Calculation tab Check Auto OK.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Excel
 

What do you mean, it's not adding it up?

Do you get the wrong total, a zero or an error?

If it's the wrong total or zero perhaps some of your numbers are text.
Try to convert them to numeric or total them with

=SUMPRODUCT(--(A1:A10)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=568834