software

sup pros

i have in cells

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

amp; 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: www.excelforum.com/member.php...foamp;userid=4062
View this thread: www.excelforum.com/showthread...hreadid=514779Enter 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
worked fine
thanx--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: www.excelforum.com/member.php...foamp;userid=4062
View this thread: www.excelforum.com/showthread...hreadid=514779Thanks for feeding back.

Pete
cheers smith
huh--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: www.excelforum.com/member.php...foamp;userid=4062
View this thread: www.excelforum.com/showthread...hreadid=514779