Forum Discussion
Excel SUM Function - Trying to Exclude Some Non-Contiguous Cells
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?
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
Oh, duh! on the column width, I feel dumb! But thank you so much for explaining the 'Subtotal' function and what the 9 means; apparently I have never used this before and did not even realize it existed. You have definitely fixed my issue! 🙂
