You only still use the function sumif.. You'd better use the function sumifs......

Still, many people use the function sumif.
Yes, the function is very useful.
I sometimes ask people to use the function "sumifs".
But they do not know how to use it.

Let me tell you.

The function is more powerful than sumif.

For instance,

See below and think about sumif and sumifs.

Can you calculate how much HR spent?

Yes, it is very easy.
If you use the function sumif, the formula is =SUMIF(C6:C12,"HR",F6:F12).
However, when you use the function sumifs, the formula is =SUMIFS(F6:F12,C6:C12,"HR")

Can I give you another question?
If you want to know that how much HR spent for January, which one is better?
Absolutely, you use sumifs than sumif. Of course, you use the function sumif.
But I do not recommend it.

Let's take a look at the picture below.

The function sumifs deals with many critical.

What if you want to know that how much Henry at HR spent on January?

Let's look at the picture below.

You just put the range and critical.

Please use the function sumifs...