COUNT function... I think!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rebekah - 06 Sep 2007 18:16 GMT

I have two colomns of data, I need to operate the count function only if the
data in both colomns, within the same row are true i.e

I need to count the how many times the trade "car" happens to be a priority
"2".

Trade    Priority
CAR    2
BRI    2
ROO    2a
ELE    2a
PLU    3
CAR    2

I have tried to use =COUNTIF, =COUNT(IF

Is this possible and what is the correct formula/function to use?

Reply to this Message

T. Valko - 06 Sep 2007 18:26 GMT

Try this:

=SUMPRODUCT(--(A1:A10="car"),--(B1:B10=2))

Better to use cells to hold the criteria:

D1 = car
E1 = 2

=SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1))

Signature

Biff
Microsoft Excel MVP

>I have two colomns of data, I need to operate the count function only if
>the
[quoted text clipped - 15 lines]
>
> Is this possible and what is the correct formula/function to use?

Reply to this Message

David Biddulph - 07 Sep 2007 08:50 GMT

=SUMPRODUCT(--(A2:A7="Car"),--(B2:B7=2))
If the priority is text, rather than a number, then you'd need quotes, so
=SUMPRODUCT(--(A2:A7="Car"),--(B2:B7="2"))

Signature

David Biddulph

>I have two colomns of data, I need to operate the count function only if
>the
[quoted text clipped - 15 lines]
>
> Is this possible and what is the correct formula/function to use?

Reply to this Message