Strange formula behavior

[AA Arens]

I use the formula: =SUM(IF((Feeder!$E$9:$E$2008=$A11),IF((Feeder!$E
$9:$E$2008=1),1,0)))

When I use the same formula to another columns and changes the $E into
$N it doesn't work.

The feeder sheet contains as data 1

I already used 1, "1", but no change.

Cell formats are the same
I copy/paste CTRL-SHIFT-ENTER

Bart
Excell 2003

 

[Bob Phillips]

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Bob Phillips]

Why are you doing the two tests, why not just test for 1? I am assuming A11
has to be 1 to get a result of 1. Other than that, it works the same for me
when I change E to N.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[AA Arens]

Why are you doing the two tests, why not just test for 1? I am assuming A11
has to be 1 to get a result of 1. Other than that, it works the same for me
when I change E to N.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

I changed the format into "Text" to have it solved. While the first
column was "General".

Solved but controversially.