Array formula

[Andrew Clark]

Hello,

Why doesn't the following work as an array formula?

=SUM(IF(ISERROR(VLOOKUP("Clark",INDIRECT(B1:B10),5,FALSE)),0,VLOOKUP
("Clark",INDIRECT(B1:B10),5,FALSE)))

where B1:B10 is a list of named ranges. Furthermore, when I try and
'Evaluate Formula', Excel crashes.

Thanks,
Andrew

 

[Don Guillett]

Have a look in HELP index for SUMIF