[Excel] compatibility of the SUMIF function, excelsumif Function

[Excel] compatibility of the SUMIF function, excelsumif Function

Two Functions with high compatibility

Compatibility, of course, SUMIF.

Here is an example.

There is a table with only two columns, "subject division" and "occurrence", but it is divided into many columns.

We need to count the total amount of "Postage.

 

What can I do? I cannot manually merge two columns?

At this time, the compatibility of SUMIF is shown.

As usual.

 

We use SUMIF to select the "amount" of "Subject division" as "Postage.

 

 

Enter = SUMIF, press the Tab key to select the SUMIF function, click Fx to open the function parameter dialog window, and enter our parameters.

 

Range is different from usual. This time, we select a region that contains "Subject division", such

 

 

Criteria still specifies your filtering condition. here we need to set "Subject division" to "Postage", so fill in "Postage ".

 

The Sum_Range parameter does not need to be selected as before. This time, you only need to tell the SUMIF function that you need the total "amount". Therefore, the Sum_Range parameter is set here.The first cell where "occurrence" is located ($ B $1)You can (do not fill in D1 or "occurrence", this is an error or invalid)

 

 

2. AVERAGEIF ()

 

After reading the usage of the above SUMIF function, we can't help but imagine whether COUNTIF has such compatibility?

 

Then try the same table ?!

 

 

 

 

Sure enough, this can also be achieved!

 

But COUNTIF is not the same. It does not have Sum_Range. It only calculates how many times the text appears.

Of course, there is no doubt that it can also be used in multiple columns.

 

 

 

Summary

 

There are also many functions with strong compatibility, just waiting for you to explore!