Excel SUMIF Not Blank Cells

In this article, we will learn about how to get a return from non-blank cells.

When you need to use excel SUM if function with some condition, we use the SUMIF function in Excel.
SUMIF Excel function gets the sum of range based on the condition and returns the recorded values.
Syntax:

=SUMIF(range, criteria , [sum_range])

Let’s understand how to do sumif in excel  with an example shown below

I want a formula preferably SUMIF function to sum the numbers in column A only if the corresponding cell in column B is not empty. I have tried to use sumif multiple columns based on non-blank cells.

SUMIF 1

So write the formula where you want to get the sum

=SUMIF(B:B,”<>”,A:A)

Explanation:
The function checks the cells which are not blank and excel if cell is not blank, it records the value of the corresponding cell. The function returns the sum of the recorded values.

Sum of values in Column A is done, a condition that the corresponding Column B should not be blank.

SUMIF 2

Press Enter to get the desired result.

SUMIF 3

Now we will remove some of the numbers from Column B.

SUMIF 4

As you can see, as I removed some numbers, the sum changed. The Formula holds the blank cells and considers only the non-blank cells in Column B and returns the sum of corresponding values in Column A.

In this way, we learnt how to use SUM IF function in Excel to get a return from the non-blank cells. You can use these functions in Excel 2016, 2013 and 2010. Find more articles on Mathematical formulation with condition here. If you have any issue regarding this article or any unresolved query, please comment in the comment box below.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube