Forum Discussion
Solved
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, an...
Hi Martinbrandt
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
Hi Martinbrandt
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
- Hi,
It was exactly what i was looking for, thanks a lot.
