It is very possible that the cells with the values are text, not numeric.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

" wrote in
message ...
I tried this and still get the same wrong answer of 0.


"Elkar" wrote:

Try writing it like this:

=C3-SUM(G1:G5)

HTH,
Elkar


" wrote:

my formula says =sum(C3-(G1:G5))
It comes up and says 0, when it should say 149.26

HELP

" wrote:

Excel incorrectly calculated a formula. Why, how do I fix it?