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