Simple Fx using addition leads to #VALUE result and I don't know why...

[brose99]

(Excel for Mac 2013) I'm sure there is a simple solution:

I am adding up every other cell in a horizontal row (A1+C1+E1+G1+I1) and totaling the numbers in these cells in cell K1.

In cell C1, there is an =IF(AND fx that results an integer, but when I add cells A1+C1+E1+G1+I1, the fx result in C1 is creating a "#VALUE" response in cell K1 rather than a sum of the numbers in the 5 aforementioned cells.

I've tried changing the format of the cells to 'General' and 'Number'...etc. but nothing is working.

Any ideas?

Thanks in advance.

 

[Toadstool]

What is the formula in C1?

 

[brose99]

[font=&quot]=if(and(q8<-2.88,q8>-6.9,r8<16.3,r8>-10,d8<-5.5,d8>-11),1,"")[/font]

 

[Toadstool]

Change that last "" to 0

 

[brose99]

Just tried it. Unfortunately, it didn't work.

Any other ideas?

 

[petertenthije]

Just tried it. Unfortunately, it didn't work.

Any other ideas?

Are the numbers in cells D8 and/or Q8 and/or R8 perhaps entered as text values?

 

[brose99]

NAILED IT! Thanks petertenthije and Toadstool!!

 

[brose99]

Solved