Sum up values from adjacent column

**Pivotrend** · 02-21-2006, 04:39 AM

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 ?

Pete_UK · 02-21-2006, 05:10 AM

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