Forum Discussion
cardsfaninmo
Apr 18, 2025Copper Contributor
Adding up column totals.
Hi,
Trying to add up values in Column G2, G2772. Can't get autosum to work right. In cell 2773 I click "Autosum" and enter cell G2, G2772 and the value in G2773 comes up 0.00. I don't know what I am doing wrong. Someone please help. Thanks
Thank you very much, it was driving me nuts.
2 Replies
Sort By
AutoSum only works for a contiguous range without blank cells.
If you want to sum G2 and G2772, use =SUM(G2,G2772)
If you want to sum all cells from G2 to G2772, use =SUM(G2:G2772)
- cardsfaninmoCopper Contributor
Thank you very much, it was driving me nuts.