"julie c." wrote:
i can get certain columns to sum, but not others, why???

One guess is that the numbers in the col are "text numbers"
Try this to convert to real numbers:
Input in an empty cell the number 1, then copy it
Then right-click on the col paste special multiply ok

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---