Max Value with Single Criteria

[Shinianne]

Im trying to get the Max value from the longest wait time for the month of Jan, Feb and Mar.i tried using =max(if($c$c="Jan",$h$h)) but it wont work, can someone help me please? thank you so much.

SkillGroup	Year	Month	Day	Total Inbound Calls	Total Calls To Queue	Total Calls Abandoned In Queue	Longest Wait Time
US Business Hours	2019	Jan	1	86	82	4	0:00:45
US Business Hours	2019	Feb	1	462	446	15	0:04:34
US Business Hours	2019	Mar	1	388	372	13	0:07:19
German Queue	2019	Feb	1	3	2	1	0:05:49
German Queue	2019	Mar	1	5	5	0	0:00:06
Spain Queue	2019	Feb	1	18	17	1	0:01:55
Spain Queue	2019	Mar	1	9	9	0	0:00:18
Portugal Queue	2019	Feb	1	9	9	0	0:00:28
Portugal Queue	2019	Mar	1	9	9	0	0:04:51
Mandarin Queue	2019	Jan	1	32	26	6	0:05:52
Mandarin Queue	2019	Feb	1	8	8	0	0:00:09
Mandarin Queue	2019	Mar	1	6	6	0	0:00:10
French Queue	2019	Feb	1	2	1	1	0:01:03
French Queue	2019	Mar	1	7	5	0	0:01:00
US Business Hours	2019	Jan	10	818	750	59	0:11:50
US Business Hours	2019	Feb	10	93	92	2	0:04:34
US Business Hours	2019	Mar	10	107	102	5	0:03:38
German Queue	2019	Jan	10	10	8	2	0:04:30
Spain Queue	2019	Jan	10	9	9	0	0:03:02
Portugal Queue	2019	Jan	10	10	10	0	0:02:11
Mandarin Queue	2019	Jan	10	17	16	1	0:01:23
Mandarin Queue	2019	Feb	10	29	28	1	0:00:59
Mandarin Queue	2019	Mar	10	6	6	0	0:00:08
French Queue	2019	Jan	10	2	2	0	0:00:20
US Business Hours	2019	Jan	11	653	599	50	0:07:28
US Business Hours	2019	Feb	11	685	669	16	0:26:02
US Business Hours	2019	Mar	11	557	554	3	0:03:20
German Queue	2019	Jan	11	8	8	0	0:00:12
German Queue	2019	Feb	11	7	7	0	0:00:23
German Queue	2019	Mar	11	17	16	1	0:03:03

 

[cunningAce]

Hi,

You are on the right lines, Just need to be entered as an array formula using Ctrl-shift-Ent

={MAX(IF($C$2:$C$31=J2,$H$2:$H$31))}

 

[Shinianne]

Hi,

You are on the right lines, Just need to be entered as an array formula using Ctrl-shift-Ent

={MAX(IF($C$2:$C$31=J2,$H$2:$H$31))}

Awesome! Its now working!