Assuming you tested your formula as a formula first, try this with OUT the
{ }

range("a2").formulaARRAY="=IF($C$2:$C$4=$D$1,$A$2: $A$4,"")"


--
Don Guillett
SalesAid Software

"jin" wrote in message
ups.com...
I'm working on a Product Evaluation Checklist in which each item has a
checkbox (yes) indicating if that item is present. The list is quite
extensive; so I as the each item is checked/ unchecked I want a list
of all unchecked items generated at the bottom of the worksheet (as a
recap).
I have the checkbox linked to a cell that equals TRUE (let's call it
C2). I'm sure there's a better way to pass the value of the checkbox,
if so please let me know.

Worksheet layout:

_____Col A_____Col B____________Col C_____Col D
R1 ITEM ITEM in SPEC FALSE
R2 widget 1 Checkbox YES TRUE
R3 widget 2 Checkbox YES FALSE
R4 widget 3 Checkbox YES TRUE
etc. etc.

I would like the recap to list all items that are out of SPEC, this is
the idea method.
R200 widget 1
R201 widget 3
R202

I have the following array formula in the recap area {=IF($C$2:$C$4=$D
$1,$A$2:$A$4,"")}.
My results using the above example gives me the following results.
R200
R201
R202
However, if I uncheck the first item (Row2) only, I get this.
R200 widget 1
R201 widget 1
R202 widget 1

Please help.

Thanks,
Jin