DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Formulas to Calculate Subtotal by Colors in Excel Office 365!!

This page will show the simple Formulas to calculate the subtotal by colors in Excel Office 365. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Formulas to subtotal by colors
Formulas to subtotal by colors

General Formula:

  • To calculate the subtotal by color in Excel, use the below formula.

=SUMIF(color_range,criteria,number_range)

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.
  • Range – It represents the input range from your workbook.
  • Criteria – It is the condition that is used to count the values.

Example:

  • Let’s consider the below example, to calculate the subtotal by colors.
  • First, you need to give the input values.
  • In the below image we will give the input values in Column B and Column C.
  • After that, enter the given formula in the selected area.
  • Finally, we will get the result in Cell F3.

Example
Example

Wind-Up:

In this article, we described the formulas used to calculate the subtotal by colors in Excel Office 365. Hope you like this article. If you have any suggestions, feel free to share it with us. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *and Excel Formulas *!!

Read Also:

Top comments (0)