Finding the most frequent value with certain criteria - MAXIF?

[Uganda]

Hello,

I have a table of data showing emails and phone calls done by different agents during different months. If I wanted to show the lowest or highest number of emails/calls done by an individual in each month, what function should I use?

[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Month[/TD]
[TD="width: 64"]class[/TD]
[TD="width: 64"]Agent[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]Email[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]Phone[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Email[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Phone[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Email[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Email[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Phone[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]Email[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]Phone[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Email[/TD]
[TD]C[/TD]
[/TR]
</tbody>[/TABLE]


Thanks in advance

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[TD]

H​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]Month[/TD]
[TD]class[/TD]
[TD]Agent[/TD]
[TD][/TD]
[TD][/TD]
[TD]MONTH[/TD]
[TD]Email[/TD]
[TD]Phone[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

11​

[/TD]
[TD]Email[/TD]
[TD]A[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]

11​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

11​

[/TD]
[TD]Phone[/TD]
[TD]A[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]

11​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

1​

[/TD]
[TD]Email[/TD]
[TD]B[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]

11​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]

1​

[/TD]
[TD]Phone[/TD]
[TD]B[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]

1​

[/TD]
[TD]Email[/TD]
[TD]C[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]

1​

[/TD]
[TD]Email[/TD]
[TD]A[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

0​

[/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD]

1​

[/TD]
[TD]Phone[/TD]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD]

11​

[/TD]
[TD]Email[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD]

11​

[/TD]
[TD]Phone[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

11​

[/TD]
[TD]

1​

[/TD]
[TD]Email[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

G2=COUNTIFS($C$2:$C$11,$E2,$A$2:$A$11,$F2,$B$2:$B$11,G$1) copy across and down

 

[Uganda]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[TD]

H​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]Month[/TD]
[TD]class[/TD]
[TD]Agent[/TD]
[TD][/TD]
[TD][/TD]
[TD]MONTH[/TD]
[TD]Email[/TD]
[TD]Phone[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

11​

[/TD]
[TD]Email[/TD]
[TD]A[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]

11​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

11​

[/TD]
[TD]Phone[/TD]
[TD]A[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]

11​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

1​

[/TD]
[TD]Email[/TD]
[TD]B[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]

11​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]

1​

[/TD]
[TD]Phone[/TD]
[TD]B[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]

1​

[/TD]
[TD]Email[/TD]
[TD]C[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]

1​

[/TD]
[TD]Email[/TD]
[TD]A[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

0​

[/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD]

1​

[/TD]
[TD]Phone[/TD]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD]

11​

[/TD]
[TD]Email[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD]

11​

[/TD]
[TD]Phone[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

11​

[/TD]
[TD]

1​

[/TD]
[TD]Email[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

G2=COUNTIFS($C$2:$C$11,$E2,$A$2:$A$11,$F2,$B$2:$B$11,G$1) copy across and down

Thanks for this; but what I was actually after was just the min or max answer to show rather than all answers a bit like what you would get with a MAXIF function?

Thanks for your help though!