Try this:

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

Or, use a cell to hold the criteria:

D1 = 1

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

--
Biff
Microsoft Excel MVP


"Browny" wrote in message
...
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
----------------------
240
The values of 1 in column A sum column B
--
Browny