autosum of autosum values always = 0

[baudi]

Hello everybody I am new to this site but enjoy working with excel for quite a few years now. I use excel a lot for making estimates.

The annoying -probably easy question- is this:

The cell command
=SUM(H38,H36,H32,H24,H17,H9)

always count up to O as the values between parentheses are autosums themselves.

How can I fix this easily?

Kind regs,

baudi

 

[barry houdini]

Hi, baudi, welcome to the board

Presumably you expect the result to be something other than zero? Usually this would indicate that the cells you are summing contain text not numbers (SUM function ignores text), although the values might look like numbers.

What formulas are in H38, H36 etc.?

 

[baudi]

excel for dummies

thnx barry but i simply f-d up my own input; autosum works fine now. found the answer on p202 in Bills 277 solved mysteries.
Nice book though.