In this tutorial, we will explain the simple Formulas used to calculate the subtotal by invoice number in Excel Office 365. Let’s get started!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- To calculate the subtotal by invoice number in Excel, use the below formula.
=IF(COUNTIF(range,criteria)=1,SUMIF(range,criteria,sum range,””)
Syntax Explanations:
- IF – The Excel** IF function** return one value for a TRUE result, and another for a FALSE result.
- COUNTIF – This function will help to count the number of cells that meet a single criterion or condition in Excel.
- 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.
- Range – It represents the input range from your workbook.
- Criteria – It is the condition that is used to count the values.
Example:
- In the below image, we will give the input values in Column B and Column D.
- Then, enter the given formula in the formula bar section.
- Finally, it will calculate the subtotal by the invoice number and show the result in Cell F4 as per the below image.
Conclusion:
In this article, you can get to know the formulas used to calculate the subtotal by the invoice number in Excel Office 365. Hope that this article is useful to you. If you have any doubts, don’t forget to share it with us. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *and Excel Formulas *!!
Top comments (0)