Subtotals – A Trick I Didn’t Know
After all of these years, I learned a new trick that you can use with the SUBTOTAL function. I’ve been using SUBTOTAL as a form of SUM, but you can also use it for counting or averaging as well as other statistical type actions. SUBTOTAL(9, “range”) gives you the sum whereas SUBTOTAL(1, “range”) gives you…
You must be logged in to post a comment.