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
|