one way:

=SUMPRODUCT(($A$1:$A$4={4598,6987})*($B$1:$B$4))

HTH

"mj" wrote:

Hello Guys,
On one sheet a have a data base.
Exempl.
A (name - code) B (value)
1 4562 120,00
2 4598 698,00
3 5987 860,00
4 6987 987,00

On the other sheet I have to write some sum's from the previous sheet.


total sales from region Europe = (4598 + 6987- code)=698,00+987,00

the problem is that the rows with codes are not on the same place all the
time. They can be aded multiple rows with other codes. Becouse of that I was
thinking to use VLOOKUP to find proper codes which they belong together and
sum it.

Can somebody give me a tip.

Regards

Mitja






--
mj