![]() ![]() The example below shows how the SUBTOTAL and the SUM functions work in unison. Thus, you will get the sum of all data without issues. The function ignores its counterparts in the selected range. ![]() If you are using the SUBTOTAL, you do not need to worry about duplicate calculations. Where the SUBTOTAL function shines is when you need to calculate all values. If the aggregation range doesn't contain any other SUBTOTAL functions, both formulas return the same result. After this, enter the other arguments as if you were using that function. ![]() To define which function you want to replicate, you need to enter its defined code as an argument. The SUBTOTAL function can replicate what other functions does. These two features make the SUBTOTAL function a perfect tool to calculate subtotals in Excel (obviously!).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |