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
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.
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!! *and Excel Formulas *!!
Top comments (0)