Thread: sum if problem
View Single Post
  #1   Report Post  
Felix Lindberg
 
Posts: n/a
Default 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!