by

# How to SUMIF in Excel

How to SUMIF in Excel

## How to SUMIF in Excel

In Microsoft Excel SUMIF is a function that you can use to sum a number from any standard.

We’ve come up with a simple example to illustrate.

First we have written the names of the countries in column A.

Then in column B we have the number of goods sold in these countries.

And now let’s turn to the formula, so in this first example, from the SUMIF, we find out how many, less than a thousand items sold.

And in this second example, we know what the total number of items sold for less than a thousand is, but we know this from a cell reference.

And now in the third example, we have tried to find out the total number of items sold in a particular country, using the same data.

Now I hope that you understand the function of the SUMIF formula through these three examples and that the following questions will be solved in your mind.

How to use sumif
How to use sumif in excel
How to use sumif function in excel
How to do sumif in excel
How to do sumif