Thread: Sum Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mchazka mchazka is offline
external usenet poster
  
Posts: 1
Default Sum Function
I accidently came across this function : sum(-a1:a5). Suppose cells a1:a5
contains 1,2,3,4,5. The returned value is -3. How does Excel derive this
value based on the formula?
Reply With QuoteReply With Quote