sup pros

i have in cells

A1:2200
A2:2200
A3:2190
A4:2180
A5:2200
A6:2170
A7:2200
A8:2200
A9:2160

& in cells

B1:1,000
B2:3,000
B3:2,000
B4:7,000
B5:2,000
B6:1,000
B7:2,500
B8:3,000
B9:1,000

i want to sum up the values in columns B if the adjacent number in
column A = 2200
which would Be the values in B1 B2 B5 B7 B8 = 11,500 because there
adjacent Cells in coulumn A reads 2200 which are A1 A2 A5 A7 A8

how do i do that ?


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=514779