how do I add all the values in a column
i need to add the values (they are in increments relating to dollars and
cents)
eg column A2 through to A147 need to be added to find the total numeric
value of the entered amounts
help apreciated as the help in excel 2000 is useless
thanks in advance
John
Rafael Ortiz - 09 Sep 2003 13:19 GMT
Go to the bottom of the column and type in the following:
=SUM(A2:A147)
MRO
> how do I add all the values in a column
> i need to add the values (they are in increments relating to dollars and
[quoted text clipped - 4 lines]
> thanks in advance
> John