Hi Mates,

I am sure that my question might have asked someone else in this forum itself and solved, i spend almost an hour by searching the answer but could't find, that is why this new thread.

The below is my data format, i need to get the SUM totals for each MONTH separately for A,B & C. (Note; I don't want to create 2 new cells with a start and end dates)

DATE COLLECT AMOUNT
1-Jan-19 A 10
2-Jan-19 B 15
3-Jan-19 C 20
4-Jan-19 A 25
5-Jan-19 A 30
6-Jan-19 B 35
7-Jan-19 B 40
8-Jan-19 C 45
1-Feb-19 C 5
2-Feb-19 A 10
3-Feb-19 B 15
4-Feb-19 C 20
5-Feb-19 C 25
6-Feb-19 C 30
7-Feb-19 B 35
8-Feb-19 A 40