Desktops
Q: How can I sum a column in numbers
I add rows into various places in a numbers spread sheet and want several column totals. But I have to edit the total fields every time I add a row.
Is there anyway to have a function called "sum this column" so it doesn't matter how many rows there are to be summed?
iMac, OS X Yosemite (10.10.5)
Posted on Nov 3, 2015 10:37 AM
by SGIII,Solvedanswer
Mac OS X
Define the row with sums as a Footer Row. Then the sum formulas can refer to the entire column, e.g. =SUM(A) =SUM(B) etc.
SG
Posted on Nov 3, 2015 1:42 PM

