i wish to lookup values in column A, & add adjacent values in colu

[Browny]

i wish to lookup values in column 'A' and sum the adjacent column(B)
eg.

A B
1 1 120
2 2 50
3 1 120

 

[T. Valko]

Try this:

=SUMIF(A1:A3,1,B1:B3)

Or, use a cell to hold the criteria:

D1 = 1

=SUMIF(A1:A3,D1,B1:B3)

 

[muddan madhu]

This one ?

=SUMPRODUCT((A1:A3=1)*(B1:B3))

 

[Browny]

Briliant, thank you
so easy when you see it.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Briliant, thank you
so easy when you see it.