Category Archives: Excel functions

Excel | Subtotal – 11 Functions in One

By | 23. 5. 2020

SUBTOTAL is a little strange function. There are 11 mathematical functions hiding inside it. We can calculate sum, arithmetic mean, spread, minimum/maximum and another statistic values using SUBTOTAL function. What’s more, we can limit whether we want to calculate even with hidden values which were hidden manually. All under roof of one function. SUBTOTAL –… Read More »