How do I solve the error this #VALUE! error

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I have a IF AND formula read 2 different cells to be true 2
sumif depending on 2 cells matching 3
Problem with an "if" relating to a range 7
CHALLENGE! - USING IF MAX MIN AND LOOKUP TOGETHER 9
Sum product help needed with an extra variable please and thankyou 6
#VALUE ERROR - How to eliminate 3
#VALUE! error 4
IF 3

Top