Still need help

[Guest]

Please see Logical Function question posted today.

 

[Guest]

What about it 'didn't work?'

 

[Backdoor Cover]

try this

=SUMPRODUCT((E6:E500=W24)*(T6:T500="1")

 

[Guest]

Excel would not let me move on because the formula was not correct.

 

[Guest]

Your formula works just fine when pasted into xl2002. Maybe somebody can
test it in 2003

BTW, it really helps us troubleshoot if you can add a little more detail to
the issue, rather than the skimpy statement that 'it doesn't work.'

 

[Backdoor Cover]

this should work then as it does on 2003


=SUMPRODUCT(($E$6:$E$500=A4)*($T$6:$T$500=1))

 

[Guest]

Thanks, but the result still comes out to be 0 when there are probably 50.

Could this be a formatting issue? When I first opened the file with Excel
2003, there were little error flags on every number entered in a column that
was not the product of a formula. I formatted them as numbers.

Let me know what other information would be helpful.

 

[Guest]

when it would not let you move on, was it highlighting any spot on the
equation?
I assume when you say not letting you move on, that it was not accepting
the equaiton and telling you there was an error.

 

[Guest]

it sounds as though the logic is not accepting one or the other of the
sections as true. find a line which looks like it should say true for both
sections and check the logical statement for each of them individually.

 

[Ken Wright]

Try this

=SUMPRODUCT(--(E6:E500=W24),(T6:T500=1))

 

[Guest]

What about:

=SUMPRODUCT(--(E6:E500=W24),--(value(T6:T500)=1))

 

[Guest]

Thanks, BJ, I have tried that - all of the formulas are the same.

 

[Guest]

It actually was highlighting several spots, but the more I changed it began
to highlight everything. It didn't tell me there was an error, because it
did give me a response, I believe I just gave the wrong command...

 

[Guest]

Thanks, Ken. I entered that equation, though, and it also returned a '0' value

 

[Guest]

Thanks, Duke, but this suggestion again returned a '0' value.

 

[Backdoor Cover]

Can you try these?

=countif(E6:E500,W24)
=countif(T6:T500,"1")

Do either of them bring up zero? If they do then your data is whacky

 

[Ken Wright]

Your call - if you want to send the workbook on down then be my guest and
I'll happily take a look. Just take the NOSPAM out of my email addy.

 

[Gord Dibben]

If the numbers were entered as Text and from your description of the error
flags, it would seem to be the case...........

Simply formatting to "number" does not make them numbers.

Copy an empty cell formatted as General or Number.

Select your range of data and Edit>Paste Special>Add>OK>Esc.

This will force them into real numbers.


Gord Dibben Excel MVP