software

i am trying to count the number of rows over 90 in column c that also have a
1 in column d

i have tried
=SUMPRODUCT(--(C5:C301gt;=quot;90quot;),--(D5301=quot;1quot;))

and only get 0 as an output

what am i doing wrong?
--
gtsch

This should work. Note there are no quot;quot;.
=SUMPRODUCT(--(C5:C301gt;=90),--(D5301=1))
--
tjquot;gtschquot; wrote:

gt; i am trying to count the number of rows over 90 in column c that also have a
gt; 1 in column d
gt;
gt; i have tried
gt; =SUMPRODUCT(--(C5:C301gt;=quot;90quot;),--(D5301=quot;1quot;))
gt;
gt; and only get 0 as an output
gt;
gt; what am i doing wrong?
gt; --
gt; gtsch


Hi gtsch

=quot;90quot; looks for text
whereas =90 looks for numbers

Drop the double quotes and your formulae should work.

gtsch Wrote:
gt; i am trying to count the number of rows over 90 in column c that also
gt; have a
gt; 1 in column d
gt;
gt; i have tried
gt; =SUMPRODUCT(--(C5:C301gt;=quot;90quot;),--(D5301=quot;1quot;))
gt;
gt; and only get 0 as an output
gt;
gt; what am i doing wrong?
gt; --
gt; gtsch--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=533980thanks that did the trick

appreciate your help
--
gtschquot;tjtjjtjtquot; wrote:

gt; This should work. Note there are no quot;quot;.
gt; =SUMPRODUCT(--(C5:C301gt;=90),--(D5301=1))
gt; --
gt; tj
gt;
gt;
gt; quot;gtschquot; wrote:
gt;
gt; gt; i am trying to count the number of rows over 90 in column c that also have a
gt; gt; 1 in column d
gt; gt;
gt; gt; i have tried
gt; gt; =SUMPRODUCT(--(C5:C301gt;=quot;90quot;),--(D5301=quot;1quot;))
gt; gt;
gt; gt; and only get 0 as an output
gt; gt;
gt; gt; what am i doing wrong?
gt; gt; --
gt; gt; gtsch