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
It's better to use SUBTOTAL() as
=SUBTOTAL(9,C5:C9)for intermediate results and
=SUBTOTAL(9,C3:C18)for grand total. Please check in attached file.
Also, I have never used the SUBTOTAL formula before. What is the 9 for in the formula?