Excel Formulas to Sum the Values in the Cells that are Non Blank!!

In this article, we will discuss the formulas to sum the values in the cells that are not blank 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

Formulas to sum the values that are not blank

General Formula:

• Use the below formula to sum the values in the cells that are not blank in Excel.

=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 text given in the worksheet.
• Sum_range – It is the input values to be added.

Example:

• Now, we are going to see how to sum the values in the cells that are not blank.
• Refer to the below image.
• Here, we will give the input values in Column C and Column D.
• Then, enter the given formula in the formula bar section.
• Finally, it shows the result in cell G3.

Example

Bottom-Line:

This page gives you a detailed view of the formulas used to sum the values in the cells that are not blank in Excel Office 365. Hope that this article is useful to you. Don’t forget to share your worthwhile feedback in the below comment section. To know further updates keep in touch with our website Geek Excel and Excel Formulas !!

Read Ahead:

• Excel Formulas to Sum the Cells that contain Formulas!!
• Formulas for Counting Cells that Contain any Text in Excel Office!!
• Excel Formulas for Counting Cells that End with certain character or text!!
• Formulas to Sum the Values by Group in Excel Office 365!!