Please see Logical Function question posted today.
--
B. Davis

What about it 'didn't work?'


"brandyda" wrote:

Please see Logical Function question posted today.
--
B. Davis

try this

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


--
Backdoor Cover
------------------------------------------------------------------------
Backdoor Cover's Profile: http://www.excelforum.com/member.php...o&userid=19842
View this thread: http://www.excelforum.com/showthread...hreadid=376072

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


"Duke Carey" wrote:

What about it 'didn't work?'


"brandyda" wrote:

Please see Logical Function question posted today.
--
B. Davis

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.'


"brandyda" wrote:

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


"Duke Carey" wrote:

What about it 'didn't work?'


"brandyda" wrote:

Please see Logical Function question posted today.
--
B. Davis

this should work then as it does on 2003


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


--
Backdoor Cover
------------------------------------------------------------------------
Backdoor Cover's Profile: http://www.excelforum.com/member.php...o&userid=19842
View this thread: http://www.excelforum.com/showthread...hreadid=376072

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.
--
B. Davis


"Backdoor Cover" wrote:


try this

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


--
Backdoor Cover
------------------------------------------------------------------------
Backdoor Cover's Profile: http://www.excelforum.com/member.php...o&userid=19842
View this thread: http://www.excelforum.com/showthread...hreadid=376072

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.

"brandyda" wrote:

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


"Duke Carey" wrote:

What about it 'didn't work?'


"brandyda" wrote:

Please see Logical Function question posted today.
--
B. Davis

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.

"brandyda" wrote:

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.
--
B. Davis


"Backdoor Cover" wrote:


try this

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


--
Backdoor Cover
------------------------------------------------------------------------
Backdoor Cover's Profile: http://www.excelforum.com/member.php...o&userid=19842
View this thread: http://www.excelforum.com/showthread...hreadid=376072

Try this

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"brandyda" wrote in message
...
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.
--
B. Davis


"Backdoor Cover" wrote:


try this

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


--
Backdoor Cover
------------------------------------------------------------------------
Backdoor Cover's Profile:
http://www.excelforum.com/member.php...o&userid=19842
View this thread:
http://www.excelforum.com/showthread...hreadid=376072

What about:

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



"brandyda" wrote:

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.
--
B. Davis


"Backdoor Cover" wrote:


try this

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


--
Backdoor Cover
------------------------------------------------------------------------
Backdoor Cover's Profile: http://www.excelforum.com/member.php...o&userid=19842
View this thread: http://www.excelforum.com/showthread...hreadid=376072

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


"bj" wrote:

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.

"brandyda" wrote:

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.
--
B. Davis


"Backdoor Cover" wrote:


try this

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


--
Backdoor Cover
------------------------------------------------------------------------
Backdoor Cover's Profile: http://www.excelforum.com/member.php...o&userid=19842
View this thread: http://www.excelforum.com/showthread...hreadid=376072

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...
--
B. Davis


"bj" wrote:

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.

"brandyda" wrote:

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


"Duke Carey" wrote:

What about it 'didn't work?'


"brandyda" wrote:

Please see Logical Function question posted today.
--
B. Davis

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


"Ken Wright" wrote:

Try this

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"brandyda" wrote in message
...
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.
--
B. Davis


"Backdoor Cover" wrote:


try this

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


--
Backdoor Cover
------------------------------------------------------------------------
Backdoor Cover's Profile:
http://www.excelforum.com/member.php...o&userid=19842
View this thread:
http://www.excelforum.com/showthread...hreadid=376072

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


"Duke Carey" wrote:

What about:

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



"brandyda" wrote:

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.
--
B. Davis


"Backdoor Cover" wrote:


try this

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


--
Backdoor Cover
------------------------------------------------------------------------
Backdoor Cover's Profile: http://www.excelforum.com/member.php...o&userid=19842
View this thread: http://www.excelforum.com/showthread...hreadid=376072

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.


--
Backdoor Cover
------------------------------------------------------------------------
Backdoor Cover's Profile: http://www.excelforum.com/member.php...o&userid=19842
View this thread: http://www.excelforum.com/showthread...hreadid=376072

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ken Wright" wrote in message
...
Try this

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--

"brandyda" wrote in message
...
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.
--
B. Davis


"Backdoor Cover" wrote:


try this

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


--
Backdoor Cover

------------------------------------------------------------------------
Backdoor Cover's Profile:
http://www.excelforum.com/member.php...o&userid=19842
View this thread:
http://www.excelforum.com/showthread...hreadid=376072

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 EditPaste SpecialAddOKEsc.

This will force them into real numbers.


Gord Dibben Excel MVP

On Thu, 2 Jun 2005 12:22:02 -0700, "brandyda"
wrote:

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.