I Need to Count Number of Entries Based on Two Criteria

In a helper column put this and copy down............

=IF(AND(B1>3,J1<>1),1,"")

Then, sum the helper column, or count the 1's whichever you
prefer..........

Vaya con Dios,
Chuck, CABGx3




"Jones" <[email protected]> wrote in message
news:[email protected]...
> I need to count the number of entries in column B only if column J does
not
> equal "1" AND column B is >3.
>
> Not looking for a "sum" or to "multiply", I simply need a count of the
> number of entries in column B that match these two criteria.
>
> I have tried combining functions through IF and COUNTIF, but have not been
> successful. Any ideas? Thanks

Try this Jones

=SUMPRODUCT((J1:J10<>1)*(B1:B10>3))


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jones" <[email protected]> wrote in message news:[email protected]...
>I need to count the number of entries in column B only if column J does not
> equal "1" AND column B is >3.
>
> Not looking for a "sum" or to "multiply", I simply need a count of the
> number of entries in column B that match these two criteria.
>
> I have tried combining functions through IF and COUNTIF, but have not been
> successful. Any ideas? Thanks

In a helper column put this and copy down............

=IF(AND(B1>3,J1<>1),1,"")

Then, sum the helper column, or count the 1's whichever you
prefer..........

Vaya con Dios,
Chuck, CABGx3




"Jones" <[email protected]> wrote in message
news:[email protected]...
> I need to count the number of entries in column B only if column J does
not
> equal "1" AND column B is >3.
>
> Not looking for a "sum" or to "multiply", I simply need a count of the
> number of entries in column B that match these two criteria.
>
> I have tried combining functions through IF and COUNTIF, but have not been
> successful. Any ideas? Thanks

Try this Jones

=SUMPRODUCT((J1:J10<>1)*(B1:B10>3))


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jones" <[email protected]> wrote in message news:[email protected]...
>I need to count the number of entries in column B only if column J does not
> equal "1" AND column B is >3.
>
> Not looking for a "sum" or to "multiply", I simply need a count of the
> number of entries in column B that match these two criteria.
>
> I have tried combining functions through IF and COUNTIF, but have not been
> successful. Any ideas? Thanks

I need to count the number of entries in column B only if column J does not
equal "1" AND column B is >3.

Not looking for a "sum" or to "multiply", I simply need a count of the
number of entries in column B that match these two criteria.

I have tried combining functions through IF and COUNTIF, but have not been
successful. Any ideas? Thanks

In a helper column put this and copy down............

=IF(AND(B1>3,J1<>1),1,"")

Then, sum the helper column, or count the 1's whichever you
prefer..........

Vaya con Dios,
Chuck, CABGx3




"Jones" <[email protected]> wrote in message
news:[email protected]...
> I need to count the number of entries in column B only if column J does
not
> equal "1" AND column B is >3.
>
> Not looking for a "sum" or to "multiply", I simply need a count of the
> number of entries in column B that match these two criteria.
>
> I have tried combining functions through IF and COUNTIF, but have not been
> successful. Any ideas? Thanks

Try this Jones

=SUMPRODUCT((J1:J10<>1)*(B1:B10>3))


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jones" <[email protected]> wrote in message news:[email protected]...
>I need to count the number of entries in column B only if column J does not
> equal "1" AND column B is >3.
>
> Not looking for a "sum" or to "multiply", I simply need a count of the
> number of entries in column B that match these two criteria.
>
> I have tried combining functions through IF and COUNTIF, but have not been
> successful. Any ideas? Thanks