B
brandyda
Please see Logical Function question posted today.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duke Carey
What about it 'didn't work?'
B
Backdoor Cover
try this
=SUMPRODUCT((E6:E500=W24)*(T6:T500="1")
=SUMPRODUCT((E6:E500=W24)*(T6:T500="1")
B
brandyda
Excel would not let me move on because the formula was not correct.
D
Duke Carey
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.'
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.'
B
Backdoor Cover
this should work then as it does on 2003
=SUMPRODUCT(($E$6:$E$500=A4)*($T$6:$T$500=1))
=SUMPRODUCT(($E$6:$E$500=A4)*($T$6:$T$500=1))
B
brandyda
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.
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.
B
bj
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.
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.
K
Ken Wright
Try this
=SUMPRODUCT(--(E6:E500=W24),(T6:T500=1))
=SUMPRODUCT(--(E6:E500=W24),(T6:T500=1))
D
Duke Carey
What about:
=SUMPRODUCT(--(E6:E500=W24),--(value(T6:T500)=1))
=SUMPRODUCT(--(E6:E500=W24),--(value(T6:T500)=1))
B
brandyda
Thanks, BJ, I have tried that - all of the formulas are the same.
B
brandyda
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...
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...
B
brandyda
Thanks, Ken. I entered that equation, though, and it also returned a '0' value
B
brandyda
Thanks, Duke, but this suggestion again returned a '0' value.
B
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
=countif(E6:E500,W24)
=countif(T6:T500,"1")
Do either of them bring up zero? If they do then your data is whacky
K
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.
I'll happily take a look. Just take the NOSPAM out of my email addy.
G
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
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