Strange formula behavior

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AA Arens - 08 Apr 2007 09:31 GMT

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

Reply to this Message

Bob Phillips - 08 Apr 2007 09:57 GMT

Signature

HTH

Bob

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

>I use the formula: =SUM(IF((Feeder!$E$9:$E$2008=$A11),IF((Feeder!$E
> $9:$E$2008=1),1,0)))
[quoted text clipped - 11 lines]
> Bart
> Excell 2003

Reply to this Message

Bob Phillips - 08 Apr 2007 09:59 GMT

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.

Signature

HTH

Bob

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

>I use the formula: =SUM(IF((Feeder!$E$9:$E$2008=$A11),IF((Feeder!$E
> $9:$E$2008=1),1,0)))
[quoted text clipped - 11 lines]
> Bart
> Excell 2003

Reply to this Message

AA Arens - 08 Apr 2007 14:24 GMT

> 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
[quoted text clipped - 26 lines]
> > Bart
> > Excell 2003

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

Solved but controversially.

Reply to this Message