SUMIFS Function

Here we can know about SUMIFS Function, That is different from SUM Function and SUMIF Function.

SUMIFS Function used for Sum of Value with different criteria.

Look at that example
Here we want to sum of Steve Sales amount in East Region. now we can use SUMIFS Function for find that value.

Just type formula syntax =SUMIFS(
Now we select Sum range in the Data i.e G4:G10,
then we select 1st criteria Range i.e E4:E10. now we select the 1st Criteria and i.e E12,
then we select 2nd criteria Range i.e F4:F10. now we select the 2nd Criteria and i.e F12.
Steve Sales Amount in East Region is 350,000 shown in G12.


Note:-
You can add multiple criteria in that Function.
Video was also uploaded for your convenience.

Subscribe our Youtube Channel

             M DOT TV