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

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

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

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

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

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

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

Briliant, thank you
so easy when you see it.
--
Browny


"T. Valko" wrote:

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

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

You're welcome!

--
Biff
Microsoft Excel MVP


"Browny" wrote in message
...
Briliant, thank you
so easy when you see it.
--
Browny


"T. Valko" wrote:

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