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
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! 🙂
technonot , you are welcome, glad to help