View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Excel incorrectly calculated a formula. Why? How?

you probably need
=C3-sum(G1:G5)

" 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?