Thread: Excel incorrectly calculated a formula. Why? How?
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Excel incorrectly calculated a formula. Why? How?
wrote...
my formula says =sum(C3-(G1:G5))
It comes up and says 0, when it should say 149.26
....

What does =COUNT(C3,G1:G5) return?

Reply With QuoteReply With Quote