This article will use blank cell as a criteria with SUMIFS functions to calculate the Sales.
Question: I have employees’ data that contains Employee, Region & Sales in separate column. Now, I want to derive the Sales figure on the basis of the blank cells in the corresponding columns.
Following is the snapshot of data we have:
The scenario is if both the columns A & B are empty then the formula should add the numbers from column C (the corresponding cells) otherwise show zero.
The above formula is showing 0 since there is no blank cells in column A & B.
In this way, we can use Excel SUMIFS function to consider the blank cells as a condition.
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.