Sum Amounts For Specific Products by Month

[samtheman509]

Hi!

I have a list of data that has Product Names in one column, date in the next, and finally Transaction amount in column C.

I am trying to find the Total Transaction Amount by month and product. How can I do this?


Example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Product Name[/TD]
[TD]Date[/TD]
[TD]Trans Amt[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]1/3/17[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]5/15/17[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Green[/TD]
[TD]4/1/17[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]5/15/17[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]6/1/17[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Yellow[/TD]
[TD]5/1/17[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]


What formula can I get that would break out the totals by product and month?

Thanks!

 

[etaf]

a pivot table would the simplest and quickest

do you know pivot tables ?

 

[etaf]

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	Product Name	Date	Trans Amt
2	Red	03/01/2017	5		Years	Date	Product Name	Sum of Trans Amt
3	Red	15/05/2017	9		2017	Jan	Red	5
4	Green	01/04/2017	6			Apr	Green	6
5	Blue	15/05/2017	4			May	Blue	4
6	Blue	01/06/2017	6				Red	9
7	Yellow	01/05/2017	1				Yellow	1
8						Jun	Blue	6
9
Sheet1

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[TD]

H​

[/TD]
[TD]

I​

[/TD]
[TD]

J​

[/TD]
[TD]

K​

[/TD]
[TD]

L​

[/TD]
[TD]

M​

[/TD]
[TD]

N​

[/TD]
[TD]

O​

[/TD]
[TD]

P​

[/TD]
[TD]

Q​

[/TD]
[TD]

R​

[/TD]
[TD]

S​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]Product Name[/TD]
[TD]Date[/TD]
[TD]Trans Amt[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]january[/TD]
[TD]february[/TD]
[TD]march[/TD]
[TD]april[/TD]
[TD]may[/TD]
[TD]june[/TD]
[TD]july[/TD]
[TD]august[/TD]
[TD]september[/TD]
[TD]october[/TD]
[TD]november[/TD]
[TD]december[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]Red[/TD]
[TD]

1/3/2017​

[/TD]
[TD]

5​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]Red[/TD]
[TD]Trans Amt[/TD]
[TD]

5​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

9​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]Red[/TD]
[TD]

5/15/2017​

[/TD]
[TD]

9​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]Green[/TD]
[TD]Trans Amt[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

6​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]Green[/TD]
[TD]

4/1/2017​

[/TD]
[TD]

6​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]Blue[/TD]
[TD]Trans Amt[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

4​

[/TD]
[TD]

6​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]Blue[/TD]
[TD]

5/15/2017​

[/TD]
[TD]

4​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]Yellow[/TD]
[TD]Trans Amt[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]Blue[/TD]
[TD]

6/1/2017​

[/TD]
[TD]

6​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]Yellow[/TD]
[TD]

5/1/2017​

[/TD]
[TD]

1​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

h2=SUMPRODUCT(($A$2:$A$7=$F2)*(TEXT($B$2:$B$7,"mmmm")=H$1)*(YEAR($B$2:$B$7)=2017)*($C$2:$C$7)) copy across and down