Sumifs Per Month With Multiple Criteria

bdenn

New Member
Joined
Feb 3, 2017
Messages
29
Office Version
  1. 365
Platform
  1. Windows
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!
 

Attachments

  • Excel Example.PNG
    Excel Example.PNG
    28.5 KB · Views: 14

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
A picture isn't helpful - it's not possible to copy/paste your data sample for testing purposes.

Try

M.
 
Upvote 0
Should be below.

Book1.xlsx
ABCDEFGHIJKLMNOP
1
2Product 1Product 2Product 3
3Type 1Type 2Type 3Type 4Type 5Type 1Type 2Type 3Type 4Type 5Type 1Type 2Type 3Type 4Type 5
401/01/2021642316819272193
501/02/2021216171142879637
602/01/2021362586855242534
702/02/2021831782823535923
803/01/2021918329145726241
903/02/2021737573459764979
1004/01/2021916758522444616
1104/02/2021661546971279844
1205/01/2021621684221596754
1305/02/2021344445442239466
14
15Type 1Type 2Type 3Type 4Type 5Need 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.
16January - 202129
17February - 2021
18March - 2021
19April - 2021
20May - 2021
Sheet1
 
Upvote 0
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.
 
Upvote 0
Solution

Forum statistics

Threads
1,213,487
Messages
6,113,938
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top