What is the use of if sumif and countif functions in Excel?

Answer 1

It allows you to sum only certain figures from a set of numbers. A regular sum will sum all values in the range. Sometimes you will not want to sum all the values, just ones that meet certain conditions. For example you could have a list of numbers in the cells from A1 to A20 and only want to add ones that are over 50. Your function would be:

=Sumif(A1:A20,">50")

The first part is the range and the second part is the condition. It must be enclosed in quotation marks.

Answer 2

The SUMIF function is used for finding the sum of numbers in range that fit a criteria. Rather than using filtering and summing, you use SUMIF.

For example if there is the following range:

A B

1 Gender Age

2 male 15

3 male 25

4 female 18

5 female 40

and you wish to find the sum of ages of females, you'd use the sumif function:

=sumif(A2:a5;"female";b2:b5)

And the answer would be 58.

Answer 3

You would use it when you only want to total some values from a list. So say you had values in A1 to A15 and you only wanted to total up the ones that were over 100, you could use a formula like this:

=SUMIF(A1:A15,">100")

Say you had the names of people in A1 to A15, and some of the names were there more than once, and you had values in B1 to B15. Then say you want to add values that are beside only one particular name that occurs a few times in the list and that name was John. You could do that with this formula:

=SUMIF(A1:A15,"John",B1:B15)

So anywhere John is found in the cells from A1 to A15, it will total the corresponding values in B1 to B15.

Answer 4

SUM adds the numbers in the ranges or values or a combination of both. To sum the values in the cells from A2 to A12, you would do the following:

=SUM(A2:A12)

You could also use SUM like this, to sum regular values:

=SUM(3,12,334,125,25,8900,234)

Answer 5

The IF function is used to make decisions based on a condition. See the related question below. The SUMIF can select some values to sum out of a set, based on a condition. See the related question below. The COUNTIF can select some values to count out of a set, based on a condition. See the related question below.

The IF function is used to make decisions based on a condition. See the related question below. The SUMIF can select some values to sum out of a set, based on a condition. See the related question below. The COUNTIF can select some values to count out of a set, based on a condition. See the related question below.

The IF function is used to make decisions based on a condition. See the related question below. The SUMIF can select some values to sum out of a set, based on a condition. See the related question below. The COUNTIF can select some values to count out of a set, based on a condition. See the related question below.

The IF function is used to make decisions based on a condition. See the related question below. The SUMIF can select some values to sum out of a set, based on a condition. See the related question below. The COUNTIF can select some values to count out of a set, based on a condition. See the related question below.

The IF function is used to make decisions based on a condition. See the related question below. The SUMIF can select some values to sum out of a set, based on a condition. See the related question below. The COUNTIF can select some values to count out of a set, based on a condition. See the related question below.

The IF function is used to make decisions based on a condition. See the related question below. The SUMIF can select some values to sum out of a set, based on a condition. See the related question below. The COUNTIF can select some values to count out of a set, based on a condition. See the related question below.

The IF function is used to make decisions based on a condition. See the related question below. The SUMIF can select some values to sum out of a set, based on a condition. See the related question below. The COUNTIF can select some values to count out of a set, based on a condition. See the related question below.

The IF function is used to make decisions based on a condition. See the related question below. The SUMIF can select some values to sum out of a set, based on a condition. See the related question below. The COUNTIF can select some values to count out of a set, based on a condition. See the related question below.

The IF function is used to make decisions based on a condition. See the related question below. The SUMIF can select some values to sum out of a set, based on a condition. See the related question below. The COUNTIF can select some values to count out of a set, based on a condition. See the related question below.

The IF function is used to make decisions based on a condition. See the related question below. The SUMIF can select some values to sum out of a set, based on a condition. See the related question below. The COUNTIF can select some values to count out of a set, based on a condition. See the related question below.

The IF function is used to make decisions based on a condition. See the related question below. The SUMIF can select some values to sum out of a set, based on a condition. See the related question below. The COUNTIF can select some values to count out of a set, based on a condition. See the related question below.

Answer 6

It is to sum numbers based on a condition. So you might have a list but only want to sum some of the numbers in it. You might want to sum only values that are over 100 for example. If the list of numbers were in the cells from A2 to A20, your SUMIF would be as follows:

=SUMIF(A2:A20, ">50")

Your condition does not have to be based on the numbers. You could have it based on some other criteria. You could have a list of amounts of sales made by different salesmen, where they could be listed multiple times in the same list. You might want to get the sales of just one person only. If the names were in A2 to A20 and the values in B2 to B20, and you were looking for sales by Tom, your SUMIF would be like this:

=SUMIF(A2:A20, "Tom", B2:B20)

Answer 7

The IF function is used to make decisions based on a condition. See the related question below. The SUMIF can select some values to sum out of a set, based on a condition. See the related question below. The COUNTIF can select some values to count out of a set, based on a condition. See the related question below.

Answer 8

SUMIF is used to sum values based on a condition. You could have a list of numbers and you want to sum only some of them. The SUMIF function specifies a range to check the condition on and then sums a range. The range it sums can be the same as the range it checks the condition on or it can be different, in which case you need to specify a second range.

Say you have a list of numbers in K1 to K10, but only want to sum the numbers in the list that are over 1300, then you would do this, noting the range is first and the criteria is second, and is enclosed in quotation marks:

=SUMIF(K1:K10,">1300")

In the previous example, the range being checked for the condition and being summed are the same. The other type is when there is a range for the condition and a range for summing. So say you have a list of names in the range A2 to A15 and beside each name you have values in the cells B2 to B15. Say the same names can appear more than once and you want to sum the values only beside one particular name. So say you wanted to sum all the values that are beside the name Jim whenever it occurs in the list, then you would do this:

=SUMIF(A2:A15,"Jim",B2:B15)

Answer 9

It produces the sum of the range you select. =SUM(A1:A12) will add all the numbers in cells A1 through A12 and display the result.

Answer 10

The Sum function is explained pretty good here,, there is even a video for it.