How do I add a column of monetary numbers

[puzzled]

I have a column of amounts of money. Just want excel to add them up and give
me a total.

 

[Gary''s Student]

Something like:

=SUM(A1:A100)

 

[Mike H]

What formula have you used?
What result did you get when you tried it?
What result did you expect to get?

Mike

 

[Peo Sjoblom]

Look in help for SUM

--


Regards,


Peo Sjoblom