How do I solve the error this #VALUE! error

J

James Rufus

I am getting a #VALUE! error for the linked formula, =IF('B1.1 &
B1.1.1'!E29:L29>0,"x").

Please help.
 
B

Bob Phillips

Try

=IF(SUM('B1.1 & B1.1.1'!E29:L29)>0,"x","")


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
J

Jerry W. Lewis

This is an array formula that must be array entered (Ctrl-Shift-Enter)

Jerry
 
Top