In this article, you will learn how to use SUMIF function with non-blank cells. SUMIF is a very useful function of excel that allows the user to sum the range based on the condition.
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.
Following is the snapshot data we have:
In this way, we can use SUMIF or SUMPRODUCT function to get the sum of all the cells from a column based on non-blank cell in the corresponding cell.
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.