jmnpinheiro
New Member
- Joined
- Sep 11, 2014
- Messages
- 4
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
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