In this tutorial, you will learn how to sum if not blank in Excel.
With the SUMIF function in Excel, we may sum cells based on multiple criteria in one column in addition to sum cells based on multiple criteria in other columns. In this post. I’ll discuss how to add values that meet multiple criteria in the same column.
Once ready, we’ll get started by utilizing real-world examples to show you how to sum if not blank in Excel.
Table of Contents
Sum if Not Blank in Excel
Before we begin we will need a group of data to sum if not blank in Excel.
First, you need to have a clean and tidy group of data to work with.
In this example, we want to look for the total amount of fruits are left in the shop excluding the empty cells. To do so, we can insert the following formula =SUMIF(A2:A8, “<>”, B2:B8).
Once we are done, you will be able to sum the not blank cells in Excel.