This one ?

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


On Sep 26, 11:27*am, Browny wrote:
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