Sum up values from adjacent column
 

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

Sum up values from adjacent column
 

Enter 2200 in C1 then in D1 enter this formula:

=SUMIF(A1:A9,C1,B1:B9)

This enables you to change the criteria in C1 without having to change
the formula - maybe relevant to your other post.

Hope this helps.

Pete

Sum up values from adjacent column
 

worked fine
thanx


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

Sum up values from adjacent column
 

Thanks for feeding back.

Pete

Sum up values from adjacent column
 

cheers smith
huh


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