Please help with this statement

[hbk018]

I have to complete the following task, but I do not know what formula I have to use, can you please give me a hand?

The statement is the following: How Many Spanish calls were handled by team blue during May 2020?

See picture below for your reference.

Thanks in advance.

 

[jtakw]

Hi,

Look into COUNTIFS

COUNTIFS function - Microsoft Support

How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.

support.microsoft.com

 

[hbk018]

Hi,

Look into COUNTIFS

COUNTIFS function - Microsoft Support

How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.

support.microsoft.com

I will try. Thanls.

 

[jtakw]

You're welcome.

Actually, looking at your Table 6, you would need SUMIFS

SUMIFS function - Microsoft Support

How to use the SUMIFS function in Excel, one of Excel’s math and trig functions, to add arguments that meet multiple criteria.

support.microsoft.com

 

[hbk018]

You're welcome.

Actually, looking at your Table 6, you would need SUMIFS

SUMIFS function - Microsoft Support

How to use the SUMIFS function in Excel, one of Excel’s math and trig functions, to add arguments that meet multiple criteria.

support.microsoft.com

I tried sumifs, but it did not work, maybe I don't know how to put the correct criteria.

 

[jtakw]

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

How Many Spanish calls were handled by team blue during May 2020?

So, following the logical requirements...according to your Table 6...
Not knowing any of the Cell/Range references, you'll have to "plug" that in...

"sum range" would be your "calls handle" Range in Table 6
"criteria_range 1" would be your "Channel" range
"criteria 1" would be your criteria, which in this case is "Spanish"
"criteria_range 2", would be your "Team" range
"criteria 2" would be your criteria, which in this case is "Team Blue"
"criteria _range 3", would be your "Date" range
"criteria 3" would be to isolate the dates in May of 2020, let's start with the beginning of May, which would be ">=5/1/2020"
"criteria_range 4", would be your "Date" range Also
"criteria 4" would be to isolate the dates in May of 2020, only, so ends at May, which would be "<=5/31/2020"

And you should have your working formula.

Besides the "sum range", all the criterion need no specific order, as long as they're there for the requirements.

 

[hbk018]

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

How Many Spanish calls were handled by team blue during May 2020?

So, following the logical requirements...according to your Table 6...
Not knowing any of the Cell/Range references, you'll have to "plug" that in...

"sum range" would be your "calls handle" Range in Table 6
"criteria_range 1" would be your "Channel" range
"criteria 1" would be your criteria, which in this case is "Spanish"
"criteria_range 2", would be your "Team" range
"criteria 2" would be your criteria, which in this case is "Team Blue"
"criteria _range 3", would be your "Date" range
"criteria 3" would be to isolate the dates in May of 2020, let's start with the beginning of May, which would be ">=5/1/2020"
"criteria_range 4", would be your "Date" range Also
"criteria 4" would be to isolate the dates in May of 2020, only, so ends at May, which would be "<=5/31/2020"

And you should have your working formula.

Besides the "sum range", all the criterion need no specific order, as long as they're there for the requiremg

 

[hbk018]

You are a life saver, that worked perfectly I was able to finish the project I was working. Thank you so very much for the assistance, you don't know how this means to me. :D

 

[hbk018]

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

How Many Spanish calls were handled by team blue during May 2020?

So, following the logical requirements...according to your Table 6...
Not knowing any of the Cell/Range references, you'll have to "plug" that in...

"sum range" would be your "calls handle" Range in Table 6
"criteria_range 1" would be your "Channel" range
"criteria 1" would be your criteria, which in this case is "Spanish"
"criteria_range 2", would be your "Team" range
"criteria 2" would be your criteria, which in this case is "Team Blue"
"criteria _range 3", would be your "Date" range
"criteria 3" would be to isolate the dates in May of 2020, let's start with the beginning of May, which would be ">=5/1/2020"
"criteria_range 4", would be your "Date" range Also
"criteria 4" would be to isolate the dates in May of 2020, only, so ends at May, which would be "<=5/31/2020"

And you should have your working formula.

Besides the "sum range", all the criterion need no specific order, as long as they're there for the requirements.

You are a life saver, that worked perfectly I was able to finish the project I was working. Thank you so very much for the assistance, you don't know how this means to me. :D

 

[jtakw]

You're welcome.

I'm glad we stepped thru it, and you were able to figure it out.