sum if problem
Hello I need help urgently
I have a spreadsheet that looks like this
a b c d e f
1 100 1 257 599
2 50 10
3 10 2 40 4 5 1
4 45
and i'm classifying the volymes in column b,d,f in numbers between 1-10
Here is the problem:
I want to sum all the 1,2,3, so if i classify b1;1 and F3;1 the sum should
be 105
I guess it should be an sum if formula but i cant figure it out
Please help me!
|