Sumifs Per Month With Multiple Criteria

[bdenn]

Hello,
I'm looking to sum the sales per month into 1 cell, I need to sum each "Type" that is the same per month.

Example:
01/01/2021 ("Product 1 Type 1" sold 2) & ("Product 2 Type 1" sold 3)
01/02/2021 ("Product 1 Type 1" sold 4) & ("Product 2 Type 1" sold 5)
Total Sold In January 2021: 14

What is the best way to accomplish this?

Attached is a photo of example data I'm working with to make this work.

Thanks for all the help!

 

[Marcelo Branco]

A picture isn't helpful - it's not possible to copy/paste your data sample for testing purposes.

Try

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

M.

 

[bdenn]

Should be below.

Book1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2		Product 1					Product 2					Product 3
3		Type 1	Type 2	Type 3	Type 4	Type 5	Type 1	Type 2	Type 3	Type 4	Type 5	Type 1	Type 2	Type 3	Type 4	Type 5
4	01/01/2021	6	4	2	3	1	6	8	1	9	2	7	2	1	9	3
5	01/02/2021	2	1	6	1	7	1	1	4	2	8	7	9	6	3	7
6	02/01/2021	3	6	2	5	8	6	8	5	5	2	4	2	5	3	4
7	02/02/2021	8	3	1	7	8	2	8	2	3	5	3	5	9	2	3
8	03/01/2021	9	1	8	3	2	9	1	4	5	7	2	6	2	4	1
9	03/02/2021	7	3	7	5	7	3	4	5	9	7	6	4	9	7	9
10	04/01/2021	9	1	6	7	5	8	5	2	2	4	4	4	6	1	6
11	04/02/2021	6	6	1	5	4	6	9	7	1	2	7	9	8	4	4
12	05/01/2021	6	2	1	6	8	4	2	2	1	5	9	6	7	5	4
13	05/02/2021	3	4	4	4	4	5	4	4	2	2	3	9	4	6	6
14
15		Type 1	Type 2	Type 3	Type 4	Type 5		Need to find out in January 2021 how many "Type 1" products where sold. When adding all the January cells we get 29 Will need for each month but should be able to drag it down.
16	January - 2021	29
17	February - 2021
18	March - 2021
19	April - 2021
20	May - 2021
Sheet1

 

[Marcelo Branco]

Try

B16
=SUMPRODUCT((MONTH($A$4:$A$13)=MONTH($A16))*($B$3:$P$3=B$15)*$B$4:$P$13)
copy down and across

M.

 

[bdenn]

Thank You!

That works well.

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.