Sumifs or Sumif

[vmjan02]

I have this table below and is there a way to do the sum of a GH with respect to month, I did tried sumifs but no luck

Any suggestion

As this is the output i am looking for
output (pervious 3 months will vary currently system month is Sep'22) get sum of each GH with respect to month.

GH	Aug-2022	Jul-2022	Jun-2022
AA	15	18	14
BB	3	5	3
CC	9	6	7

Table.

GH	Account Manager	Apr-2022	May-2022	Jun-2022	Jul-2022	Aug-2022
AA	ZZ	2	4	4	4	4
AA	ZZ	0	0	1	2	2
AA	ZZ	4	6	6	7	4
AA	ZZ	2	4	2	2	3
AA	ZZ	0	0	1	3	2
BB	D	3	1	0	0	2
BB	D	1	2	1	2	1
BB	D	3	7	2	3	0
BB	D
BB	D
CC	PD	0	2	3	3	3
CC	PD	1	5	3	2	3
CC	PD	4	5	0	0	2
CC	PD	0	0	0	0	0
CC	PD	3	1	0	0	0
CC	PD	1	0	1	1	1
CC	PD	0	0	0	0	0

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G
1	GH	Account Manager	01/04/2022	01/05/2022	01/06/2022	01/07/2022	01/08/2022
2	AA	ZZ	2	4	4	4	4
3	AA	ZZ	0	0	1	2	2
4	AA	ZZ	4	6	6	7	4
5	AA	ZZ	2	4	2	2	3
6	AA	ZZ	0	0	1	3	2
7	BB	D	3	1	0	0	2
8	BB	D	1	2	1	2	1
9	BB	D	3	7	2	3	0
10	BB	D
11	BB	D
12	CC	PD	0	2	3	3	3
13	CC	PD	1	5	3	2	3
14	CC	PD	4	5	0	0	2
15	CC	PD	0	0	0	0	0
16	CC	PD	3	1	0	0	0
17	CC	PD	1	0	1	1	1
18	CC	PD	0	0	0	0	0
19
20
21
22	GH	01/08/2022	01/07/2022	01/06/2022
23	AA	15	18	14
24	BB	3	5	3
25	CC	9	6	7
Data

Cell Formulas
Range	Formula
B23:D25	B23	=SUMPRODUCT(($A$2:$A$18=$A23)*($C$1:$G$1=B$22)*($C$2:$G$18))