We all start with SUM. It’s simple and reliable — until your data gets messy. Once you begin filtering or hiding rows, SUM no longer reflects what you see. That’s when SUBTOTAL helps. It can ignore ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results