Forum Discussion
Solved
Excel SUM Function - Trying to Exclude Some Non-Contiguous Cells
I would like to Sum a column but exclude certain cells from that summing process, as they contain subtotals (so I do not want to add them twice). I have searched the web high and low and tried multi...
Make the column wider , in protected view it doesn't expand automatically. It shall be as
9 means sum. Please check SUBTOTAL function
This was SO MUCH easier in Lotus123!!!
Why do we have to remember the "function number"?? Instead of writing "9" in this formula, can one write =subtotal(total,c3:c18)