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?