search and sum :)

[domdc1]

Hi everyone - ive done this before & for the life of me cant remember how.....
I need to add up all the values within a month. For example Jan would come back with 60 (5+25+30) feb with 25, march with 10 & april with 10


Feb 20 ----------------- jan 60
Jan 5 ----------------- feb 25
Mar 10 ----------------- march 10
April 10 ----------------- april 10
Jan 25
Jan 30
Feb 5

Any help as usual is appreciated
thx

 

[Scott Huish]

Formula in D1:
=SUMIF(A:A,C1,B:B)

Copy down.

Book3
	A	B	C	D
1	Feb	20	Jan	60
2	Jan	5	Feb	25
3	Mar	10	Mar	10
4	Apr	10	Apr	10
5	Jan	25	May	0
6	Jan	30	Jun	0
7	Feb	5	Jul	0
8			Aug	0
9			Sep	0
10			Oct	0
11			Nov	0
12			Dec	0
Sheet1