In a budget, I want to add all 12 months of one particular expense, eg all the electric bills, to see what I spent for the year on that particular portion of my expenses. I can only find instructions for adding the figures in "columns". Perhaps Numbers doesn't provide that option? If you know how to do this, please explain VERY simply! Thank you.
Earlier Mac models
The expression for the sum of all entries in row 2 would be: =SUM(2:2). Remember that anything that doesn't belong in the SUM must be in a Header Cell.
Jerry
The expression for the sum of all entries in row 2 would be: =SUM(2:2). Remember that anything that doesn't belong in the SUM must be in a Header Cell.
Jerry
If the "total" column is not a header column, like shown in Jerry's post, it will be a circular reference error because the cell with the sum is being included in the sum. If it is not that, when you click on the triangle what is the error?
You can always do a range of cells like =SUM(B2:M2) instead of summing the entire row.
I tried putting “=sum (2:2)” in the total column of row 2 after the December column, hoping for the sum of all in row two to appear. I only get the exclamation in the triangle.
What is the error description that you see when you click on the triangle?
Jerry
I want to add all figures in a ROW, not a column.
