a couple of laughzillas on a blue diamond background

Converting SUMs to SUBTOTALs

Jul13
by on July 13, 2015 at 2:23 pm
Posted In: Around the Web, Counting and Summing Functions, VBA

Everyone knows that SUBTOTAL ignores filtered rows. Readers of DDoE know that SUBTOTAL also ignores other SUBTOTAL formulas. I tell everyone who will listen about the benefits of SUBTOTAL. It’s one of the best received tips in the ‘Tips and Tricks’ portion of the training I do. But I still get spreadsheets that use SUM […]

└ Tags: