SOLVED

Highlighted
New Contributor

# formular for looking up more than one number

Hi, I am currently looking for af fomular.

I have to build a system so that i can look up diffrent numbers, and if the number appears, i needs it's value. The number can appear more than once, and if it does that, i need excel til + all numbers togehter.

it looking a bit like this:
i need to look up the number 300.

300    0,5
500    0,7
200    0,4
501    1,7
300     0,8
100     1,0

300     2,0

in this case i will sum til 0,5+0,8+1,0 = 2,3

Appreciate all help that i can get

3 Replies
Highlighted
Best Response confirmed by Martinbrandt (New Contributor)
Solution

# Re: formular for looking up more than one number

If I understand you clearly. You need to sum all the value associated with 300. In this case, you can use SUMIF or SUMIFS in case you want additional criteria.

``=SUMIFS(B4:B10,A4:A10,C2)``

See attached worksheet for more.

Cheers.

Emmanuel

Highlighted

# Re: formular for looking up more than one number

Hi,

It was exactly what i was looking for, thanks a lot.
Highlighted

# Re: formular for looking up more than one number

Great to know it was helpful.

Please mark as the solution to close the discussion.