meet criteria between ranges

Hi,

I want to test a criteria between range A (column A) and range B (column B).
So, for every A value I want it to test the condition, say "IF A+B > 10, write SUM result to column C".
The problem is that I want every A values to be tested with every B values (not only the ones in same lines).
Of couse, column C could result bigger than A and B columns.

I tried:
={IF(A1:A$20+B1:B$20>10;A1+B1;"")}
={IF(A$1:A$20+B$1:B$20>10;A1+B1;"")}
={IF(A1:A$20+B1:B$20>10;A1+B1;"")}

and many more array variations...

I think I'm not even close

Thanks in advance

imagine all true
A1 + B1 > 10 sum goes in C1
A1 + B2 > 10 where is sum? C2 ?
A2 + B1 > 10 now where is sum? C1 and C2 are taken...
too many variables, no where to put results.
at least from what i understand...

You understood it perfectly and I had some doubts about excel's capabilities on solving this.
Maybe the result could be a dynamic range..send answers to next blank row..

Thanks anyway

newdoverman,

that was a brilliant way to get to a solution

I'm working on some thousands paired records, col A and B......col C and D.
I'll try your approach on my datasets!!
Thank You very much