Return sum of values based on lookup-function

B

Braute

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
 
M

Max

.. 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDEX MATCH SMALL 13
Sum if value above is X 4
Lookup 3
Hlookup 3 criteria?? 0
Sum of a Look up Value 1
Lookup Values, return multiple. 4
Lookup assistance needed 9
Yearly sum 3

Top