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.
0 Comments