Return sum of values based on lookup-function
 

Hi ! I want to do as follows: I work in another worksheet than the data.
Wanting to find the same 6-digit number in the other worksheet and return the
value from column B to the other worksheet. that works when the 6-digit no.
appears in one row. But for th no: 879048 I would like to return the sum of
the three rows, in total 7618 - how can I do that? I use Office 2003

=LOOKUP($A8;$A$2:$A$5;(B$2:S$5))
=LOOKUP($A9;$A$2:$A$5;(B$2:S$5))
A B
1 UB
2 87 90 48 3806
3 87 90 48 2156
4 87 90 48 1656
5 87 90 51 1856
6
7 another worksheet
8 87 90 48 N/A I can not get the sum of 7618 to this cell
9 87 90 51 1856 works OK

Return sum of values based on lookup-function
 

.. would like to return the sum of the three rows, in total 7618
SUMIF will do the necessary

In A8 is: 87 90 48
Then in B8: =SUMIF(A$2:A$5,A8,B$2:B$5)
to return: 7618

Adapt the delimiter to suit your Excel
(change the commas to semicolons)

Celebrate? Click YES below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"Braute" wrote:
Hi ! I want to do as follows: I work in another worksheet than the data.
Wanting to find the same 6-digit number in the other worksheet and return the
value from column B to the other worksheet. that works when the 6-digit no.
appears in one row. But for th no: 879048 I would like to return the sum of
the three rows, in total 7618 - how can I do that? I use Office 2003

=LOOKUP($A8;$A$2:$A$5;(B$2:S$5))
=LOOKUP($A9;$A$2:$A$5;(B$2:S$5))
A B
1 UB
2 87 90 48 3806
3 87 90 48 2156
4 87 90 48 1656
5 87 90 51 1856
6
7 another worksheet
8 87 90 48 N/A I can not get the sum of 7618 to this cell
9 87 90 51 1856 works OK