B
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
eg.
A B
1 1 120
2 2 50
3 1 120
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
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)
=SUMIF(A1:A3,1,B1:B3)
Or, use a cell to hold the criteria:
D1 = 1
=SUMIF(A1:A3,D1,B1:B3)
M
muddan madhu
This one ?
=SUMPRODUCT((A1:A3=1)*(B1:B3))
=SUMPRODUCT((A1:A3=1)*(B1:B3))
B
Browny
Briliant, thank you
so easy when you see it.
so easy when you see it.
T
T. Valko
You're welcome!
--
Biff
Microsoft Excel MVP
--
Biff
Microsoft Excel MVP
Browny said:Briliant, thank you
so easy when you see it.