Return Text based on Max Sum of number values by month

[savvysum]

Hi,
This is for Excel.

I need a formula that returns the text when using a sum max for a number by date.
In the below example, AA02 is the answer for January 2023 b/c 4,120 is the max sum (3,995 + 125).

cell A1	1/31/2023	2/28/2023
Result	AA02	CCC
data set
Month Year	SKU	total
1/31/2023	AA02	3995
1/31/2023	MCT06	100
1/31/2023	AA02	125
1/31/2023	MCT06	125
2/28/2023	AAA	100
2/28/2023	AAA	100
2/28/2023	AAA	100
2/28/2023	BBB	250
2/28/2023	BBB	250
2/28/2023	CCC	900

 

[Phuoc]

Try this

Book1
	A	B	C
1	cell A1	1/31/2023	2/28/2023
2	Result	AA02	CCC
3		AA02	CCC
4	data set
5	Month Year	SKU	total
6	1/31/2023	AA02	3995
7	1/31/2023	MCT06	100
8	1/31/2023	AA02	125
9	1/31/2023	MCT06	125
10	2/28/2023	AAA	100
11	2/28/2023	AAA	100
12	2/28/2023	AAA	100
13	2/28/2023	BBB	250
14	2/28/2023	BBB	250
15	2/28/2023	CCC	900
Sheet1

Cell Formulas
Range	Formula
B3:C3	B3	=INDEX($B$6:$B$15,MATCH(MAX(SUMIFS($C$6:$C$15,$A$6:$A$15,B1,$B$6:$B$15,$B$6:$B$15)),SUMIFS($C$6:$C$15,$A$6:$A$15,B1,$B$6:$B$15,$B$6:$B$15),0))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[savvysum]

thank you, is there a way to have a formula without an array?

 

[Phuoc]

Excel 365 just needs Enter.

 

[savvysum]

OK, and what would the formula be if it were google sheets?