Column G:K have VLOOKUPIF formulas in them and in column L I have the [If
(sum(G4:K4)1,"","Blank")] formula that is retuning (Blank) for every row.
Listed below is the column headers plus 3 rows.

G | H | I | J
| K | L
[1]StockRM 01| StockRM 02| StockRM 03| StockRM 04| StockRM 06| ENTERED
[2] |2 |3 | |

[3]1 |2 |3 |4 |
[4] | | | |6
[5] |2 |3 | |




"HALinNY" wrote:



"Johnny" wrote:

Unforunately that did not work. The result of [If (sum(G4:K4)1,"","Blank")]
is (Blank) for every row.

"John" wrote:


That's good news, Johnny. You got rid of the #VALUE! errors. You are on
your way to success.

What you need to do now is tell us more about what you are doing. Maybe you
could show us a few rows of your data with actual values.

B+
HALinNY