#### jmnpinheiro

##### New Member

- Joined
- Sep 11, 2014

- Messages
- 4

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