DEV Community

loading...

Excel Formulas to Sum the Cells that Begin with Specific Values!!

excelgeek profile image Andrews Originally published at geekexcel.com on ・2 min read

In this tutorial, we will explain the simple formula used to sum the cells with the basic syntax and practical examples. Let’s see how to sum the cells that begin with specific values or criteria in Excel Office 365. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Formulas to sum the cells that begin with
Formulas to sum the cells that begin with

General Formula:

  • To sum the cells that begin with specific values in Excel, use the below formula.

=SUMIF(range,”text*”,sum_range)

Syntax Explanations:

  • SUMIF – The Excel SUMIF Function will help to sum the cells that meet a single condition or criteria.
  • Multiplication (*) – In this symbol will multiply any two values or numbers.
  • Text – It is the specific value or criteria which is used to sum the cells.
  • Sum_Range – It represents the input values given in the worksheet.
  • 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 values given in the worksheet.

Example:

  • In the below example image, we will show how to sum the cell that begins with a certain value.
  • First, we will give the input values in Column B and Column C.
  • Then, enter the given formula in the formula bar section.
  • Finally, we will get the result in the selected Cell F3.

Example
Example

Bottom-Line:

From this tutorial, you can get some clarification on the formulas to sum the cells that begin with specific values in Excel Office 365. Hope that this article is useful to you. If you have any suggestions, feel free to share it with us. Thank you so much for Reading!! Keep learning on Geek Excel!! *and Excel Formulas *!!

Read Also:

Discussion

pic
Editor guide