why doesn't countif function?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dindigul - 12 Jul 2007 19:18 GMT

I typed:
=countif(AND(C:C="BSM11",D:D>0,2))
why I keep getting messages like, you have not entered sufficient items or
error in formula?
THanks

Reply to this Message

Rick Rothstein (MVP - VB) - 12 Jul 2007 19:31 GMT

>I typed:
> =countif(AND(C:C="BSM11",D:D>0,2))
> why I keep getting messages like, you have not entered sufficient
> items or error in formula?

COUNTIF is looking for two arguments... AND returns a single value... a
Boolean (either TRUE or FALSE).

Since you have two different conditions to meet, try using two COUNTIF
functions (one for each condition) and add them together.

Rick

Reply to this Message

Bernie Deitrick - 12 Jul 2007 19:41 GMT

=SUMPRODUCT((C1:C100="BSM11")*(D1:D100>0))

Not sure why you'rthrowing the 2 in there as well....

HTH,
Bernie
MS Excel MVP

>I typed:
> =countif(AND(C:C="BSM11",D:D>0,2))
> why I keep getting messages like, you have not entered sufficient items or error in formula?
> THanks

Reply to this Message

Harlan Grove - 12 Jul 2007 22:27 GMT

"dindigul" <padhy...@gmail.com> wrote...

>I typed:
>=countif(AND(C:C="BSM11",D:D>0,2))
>why I keep getting messages like, you have not entered sufficient
>items or error in formula?

Because COUNTIF has specific syntax that you're failing to use. It
takes two and only two mandatory arguments, and the first one must be
a reference to a single-area range in an open workbook.

FWIW, if you're running Excel 2007, you could use

=COUNTIFS(C:C,"=BSM11",D:D,">0.2")

Reply to this Message