I think you mean

=SUMPRODUCT(--(SUMIF(INDIRECT(CHAR({2,4,6}+64)&"1:"&CHAR({2,4,6} +64)&"5"),1,
INDIRECT(CHAR({1,3,5}+64)&"1:"&CHAR({1,3,5}+64)&"5 "))))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Felix Lindberg" <Felix wrote in message
...
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!