It should add all three cells.
It works for me.

Does your formula in E4 work?
Is the result in E4 numeric?

Greetings from New Zealand
Bill K
"PaulStroik" wrote
in message ...

When I try to enter a formula in a fourth column get a sum of three
other columns only two of the three other columns work. The one column
which does not has an extensive formula to it. Would this be the reason
why? I receive no errors when entering the column 4 formula. Here is the
formula I enter in E7.

=SUM(E4,E5,E6)

Only E5 and E6 work. E4 has another formula in it. Would this cause it
not to work in the total of E7?

Thanks in advance for any help in this.


--
PaulStroik
------------------------------------------------------------------------
PaulStroik's Profile:
http://www.excelforum.com/member.php...o&userid=24640
View this thread: http://www.excelforum.com/showthread...hreadid=382343