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 multiple formulas without success. The best I can get is a #VALUE! error. I know I've done this type of formula in the past with an earlier version of Excel, but cannot do it with this version (Office 10 Pro). Thanks.
Make the column wider , in protected view it doesn't expand automatically. It shall be as
9 means sum. Please check SUBTOTAL function
7 Replies
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)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?
Hi Sergei and thanks for your response, but when I open this doc in protected view on my computer, this is what I see (see attached) - a bunch of ###### signs in the Total column. Why??
Make the column wider , in protected view it doesn't expand automatically. It shall be as
9 means sum. Please check SUBTOTAL function
