< Go Back

Sum if not blank

Sum if not blank is a very useful function of excel with which users can sum the range depending on the condition using this function. To sum the cells having values which are not blank, the SUMIF function can be used. SUMIF is one of the significant functions in excel. It works both on sum if not blank and sum if blank. In this article, we will discuss how to perform sum if not blank function in Excel.

Formula

To perform sum if not blank in excel spreadsheet, the following formula will be used:

=Sumif(range,criteria,[sum range])

How to Perform Sum If Not Blank in Excel?

You can use sum if not blank function to sum cells when certain values are not blank. The SUMIF function supports all of the operators of Excel including <> (not equal to). In the formula mentioned above, when you use an operator like <> in the criteria for sum if not blank function, always use double quotes (“”) to enclose it. Using “<>” in the criteria implies “not empty” or “not equal to empty”.

Example 1

In this example, I use the sum if not blank function to sum the numbers in column A only if the parallel cell in column B is not empty or not equal to empty.

  • I have used SUMIF multiple columns on the basis of non-blank cells. See screenshot

Figure 1. Example of Sum If Not Blank Step 1

  • In cell E2, the formula for sum if not blank is =SUMIF(B:B,”<>”,A:A). See screenshot

Figure 2. Example of Sum If Not Blank Step 2

  • If you delete any cell from column B, then the result will be as follow:

Figure 3. Example of Deleting Cells in Sum If Not Blank Function

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar