Subtotal invoices by age

In order to calculate the subtotal of invoices by age, the Excel SUMIF function can be used. This function, like in other previous sum categories, will use the same range and criteria but for subtotal invoices, there will be slight changes in the syntax used. The basic layout for this function is:

Formula

The formula to be used here is:

= SUMIF( age, criteria, amount)

Where:

  • Age is the named range for age group
  • Criteria are the specified limit for the age group
  • Amount is the total range for the amount group

Example

As stated above, in order to calculate the subtotal of invoices by age, the SUMIF function is used that will easily present us with the results.

In the following example, the formula used in cell H6 is:

=SUMIF(age, G6, amount)

Where age is the named range for E6:E12

And the amount is the named range for D6:D12

The SUMIF function just like sum processes and it uses the same three arguments, range, criteria and sum_range. In this case, we will specify the three arguments as:

  • Range is the range of cells (E6: E12) that is aligned with the criteria in the G column.
  • Criteria: G6 is the reference that contains the criteria.
  • Sum_range: it is the range of cells (D6: D12) that is summed where the criteria is TRUE.

Figure 1: Example layout of using the SUMIF function for invoice subtotal

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar