May 07 2020 08:27 AM
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 :)
May 07 2020 08:48 AM
Solution
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
May 07 2020 09:08 AM
May 07 2020 11:06 AM
May 07 2020 08:48 AM
Solution
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