multiple criteria for count if

[gtsch]

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:C301>="90"),--(D5:D301="1"))

and only get 0 as an output

what am i doing wrong?
--
gtsch

[John James]

Hi gtsch

="90" looks for text
whereas =90 looks for numbers

Drop the double quotes and your formulae should work.

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:C301>="90"),--(D5:D301="1"))

and only get 0 as an output

what am i doing wrong?
--
gtsch

[tjtjjtjt]

This should work. Note there are no "".
=SUMPRODUCT(--(C5:C301>=90),--(D5:D301=1))
--
tj


"gtsch" wrote:

> 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:C301>="90"),--(D5:D301="1"))
>
> and only get 0 as an output
>
> what am i doing wrong?
> --
> gtsch

[gtsch]

thanks that did the trick

appreciate your help
--
gtsch


"tjtjjtjt" wrote:

> This should work. Note there are no "".
> =SUMPRODUCT(--(C5:C301>=90),--(D5:D301=1))
> --
> tj
>
>
> "gtsch" wrote:
>
> > 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:C301>="90"),--(D5:D301="1"))
> >
> > and only get 0 as an output
> >
> > what am i doing wrong?
> > --
> > gtsch