## DEV Community is a community of 554,873 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

# Excel Formulas to Sum the values in Cells that contain an Asterisk!! Andrews Originally published at geekexcel.com on ・2 min read

This page will discuss the formulas to sum the values in the cells that contain an Asterisk 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:

• To sum the values in the cells that contain an asterisk in Excel, use the below formula.

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

## Syntax Explanations:

• SUMIF – The Excel SUMIF Function will help to sum the cells that meet a single condition or criteria.
• 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 data given in the worksheet.
• Asterisk (*) – An asterisk (*) means “one or more characters”.
• Tilda (~) – In Excel, this symbol act as a marker to indicate the next character.
• Sum-range – It represents the input values given in the worksheet.

## Example:

• Now we are going to see how to sum the values in the cells that contain an asterisk in Excel.
• Refer to the below image.
• First, you need to give the input values.
• Here, we will give the input values in Column B and Column C.
• Then, enter the given formula in the formula bar section.
• Finally, it displays the result in the selected Cell F2. 