Need Help

[uswyne]

Date	Station	Amount			Jan	Feb	Mar
1/7/17	BWP	5000		BWP
1/5/17	BWN	10000		BWN
2/9/17	BWP	5000		RYK
2/9/17	RYK	15000		BWR
2/25/17	BWR	3000
2/20/17	BWN	7000
3/14/17	RYK	17000
315/17	BWP	20000

<tbody>
</tbody>

Can anyone help me out to putting formula to grab the data exactly

 

[Peter_SSs]

Welcome to the MrExcel board!

Does this formula, copied across and down, do what you want?

Excel 2016 (Windows) 32 bit
	A	B	C	D	E	F	G	H
1	Date	Station	Amount			Jan	Feb	Mar
2	7/01/2017	BWP	5000		BWP	5000	5000	20000
3	5/01/2017	BWN	10000		BWN	10000	7000	0
4	9/02/2017	BWP	5000		RYK	0	15000	17000
5	9/02/2017	RYK	15000		BWR	0	3000	0
6	25/02/2017	BWR	3000
7	20/02/2017	BWN	7000
8	14/03/2017	RYK	17000
9	15/03/2017	BWP	20000
uswyne

Cell Formulas
Range	Formula
F2	=SUMPRODUCT(--(TEXT($A$2:$A$9,"mmm")=F$1),--($B$2:$B$9=$E2),$C$2:$C$9)

 

[uswyne]

Thank you very very much

 

[Peter_SSs]

Thank you very very much

You are welcome.