Thread: Will add, won't sum?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Will add, won't sum?
Your data are Text value so it won't work with =SUM(A1:A2)
you can get around with Sum function with this =SUM(--A1,--A2)


"dlw" wrote:

I copied some numbers from an Access query into an Excel 2000 spreadsheet.
When you sum them, it comes up 0, when you just add them, it works. For
example =(a1+a2) gives the right answer, =sum(a1.a2) gives 0.
What causes that?
Reply With QuoteReply With Quote