Subtotal invoices by age in Excel
This tutorial shows how to Subtotal invoices by age in Excel using the example below;
If you need to subtotal invoice amounts by age, you can easily do so with the SUMIF function.
In the example shown, the formula in G5 is:
Where age is a named range for the range E5:E11, and amount is a named range for D5:D11.
How this formula works
The SUMIF function takes three arguments: range, criteria, and sum_range.
In this case, we are using:
Range: the range of cells (E5:E11) to which criteria in column G is applied.
Criteria: G5 – a reference to the adjacent cell in column G, which contains the criteria. This is a relative address so that it will change when copied down.
Sum_range: the range of cells (D5:D11) that is summed when the criteria is TRUE.