Forum Discussion
novice365
Nov 09, 2021Copper Contributor
GETTING TOTALS IN EXCEL
In Word tables, there is a cute Formula utility whereby one can sum the cells above, below, left or right of a chosen cell. Such an elegant tool is missing in Excel or at least I have not found it! ...
mathetes
Nov 09, 2021Gold Contributor
You have GOT to be kidding. The SUM function is one of the most basic, wide-spread, primary reasons people use Excel in the first place. I can pretty confidently assert that Word "copied it" from Excel, that word processors copied that capability from spreadsheets (given that Excel really wasn't the first spreadsheet).....
See the attached spreadsheet for several examples.