How do I sum a column of numbers
How do I sum a column of numbers?
iPad 2, iOS 4.3.2
Hi escobardaniel,
Are the cells formatted as text? SUM ignores text values.
Try a Currency format.
Regards,
Ian.
Apple Event: May 7th at 7 am PT
Question marked as
Best reply
Answer 1:
=SUM(range)
where range would be something like B2:B20 or whatever range of cells you want to sum.
Answer 2:
=SUM(B) to sum the entire column B
But this formula cannot be in the same column unless it is in a header or a footer.
16 replies
How do I sum a column of numbers