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:

Product Name	Date	Trans Amt
Red	1/3/17	5
Red	5/15/17	9
Green	4/1/17	6
Blue	5/15/17	4
Blue	6/1/17	6
Yellow	5/1/17	1

<tbody>
</tbody>

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]

A​

B​

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

M​

N​

O​

P​

Q​

R​

S​

1​

Product Name

Date

Trans Amt

january

february

march

april

may

june

july

august

september

october

november

december

2​

Red

1/3/2017​

5​

Red

Trans Amt

5​

0​

0​

0​

9​

0​

0​

0​

0​

0​

0​

0​

3​

Red

5/15/2017​

9​

Green

Trans Amt

0​

0​

0​

6​

0​

0​

0​

0​

0​

0​

0​

0​

4​

Green

4/1/2017​

6​

Blue

Trans Amt

0​

0​

0​

0​

4​

6​

0​

0​

0​

0​

0​

0​

5​

Blue

5/15/2017​

4​

Yellow

Trans Amt

0​

0​

0​

0​

1​

0​

0​

0​

0​

0​

0​

0​

6​

Blue

6/1/2017​

6​

7​

Yellow

5/1/2017​

1​

<tbody>
</tbody>

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