My USA syntax for a range is a colon instead of a period.

--
Don Guillett
SalesAid Software

"dlw" wrote in message
...
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?