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.
To perform sum if not blank in excel spreadsheet, the following formula will be used:
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”.
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