Excel Formulas to Calculate the Subtotal Invoices by Age!!
Tags: excelformula, excelformulas
Published: 2020-11-23 10:47:05

---
title: Excel Formulas to Calculate the Subtotal Invoices by Age!!
published: true
date: 2020-11-23 10:36:51 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-the-subtotal-invoices-by-age/
---

This page will guide you to learn the **Formulas to calculate the subtotal by invoice amounts by age in Excel Office 365**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to calculate the subtotal invoices by age](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-calculate-the-subtotal-invoices-by-age.png)](https://geekexcel.com/excel-formulas-to-calculate-the-subtotal-invoices-by-age/formulas-to-calculate-the-subtotal-invoices-by-age/#main)<figcaption id="caption-attachment-17859">Formulas to calculate the subtotal invoices by age</figcaption>
## General Formula:

- If you need to subtotal invoice amount by age, use the below formula.

**=SUMIF(age, criteria, amount)**

## Syntax Explanations:

- **SUMIF** – It will return the sum of cells that meet a single condition. Read more on the **SUMIF Function**.
- **Comma symbol (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **(Amount) Range** – It represents the input range from your workbook.
- **Criteria** – It is the condition that is used to sum the values.

## Example:

- Let’s consider the below example to calculate the subtotal by age.
- In the below image, we will give the input values in **Column D** and **Column E**.
- After that, enter the given formula in the formula bar section.
- Finally, we will get the result in the selected **Cell H4**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-56.png)<figcaption id="caption-attachment-17858">Example</figcaption>

## Bottom-Line:

From this tutorial, you can get some clarification about the **formulas used to calculate the subtotal invoices by age in Excel Office 365**. Hope that this article is useful to you. If you have any **queries,** feel free to share it with us. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- [**Formulas to Count Multiple Criteria and OR Logic with COUNTIFS!!**](https://geekexcel.com/formulas-to-count-multiple-criteria-and-or-logic-with-countifs/)
- **[Formulas to Count Rows that meet OR Logic in Excel Office 365!!](https://geekexcel.com/formulas-to-count-rows-that-meet-or-logic-in-excel-office-365/)**
- **[Excel Formulas to Count Rows that meet Multiple OR Criteria!!](https://geekexcel.com/excel-formulas-to-count-rows-that-contain-multiple-or-criteria/)**
- **[Excel Formulas to Count Visible Rows in a Range!!](https://geekexcel.com/excel-formulas-to-count-visible-rows-in-a-range/)**