Excel - COUNTIF Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jsk - 07 Nov 2006 00:40 GMT

Could someone help me? I am inexperienced Excel user. I am trying to create
a function that will look at two columns of data and tell me how many
occurances there are when column A equals a certain value when column B
equals a certain value. I.E., column A = dog and column B = brown.
Thank you.

Reply to this Message

RagDyer - 07 Nov 2006 01:12 GMT

Try this:

=SUMPRODUCT((A1:A50="dog")*(B1:B50="brown"))

It might be more advantageous to assign cells to contain your criteria, so
that they can be more easily changed without having to revise the formula
itself.

Column A criteria in C1,
And Column B criteria in C2:

=SUMPRODUCT((A1:A50=C1)*(B1:B50=C2))

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> Could someone help me? I am inexperienced Excel user. I am trying to
> create
> a function that will look at two columns of data and tell me how many
> occurances there are when column A equals a certain value when column B
> equals a certain value. I.E., column A = dog and column B = brown.
> Thank you.

Reply to this Message

jsk - 07 Nov 2006 01:26 GMT

Thank you very much RagDyer. That works.
jsk

> Try this:
>
[quoted text clipped - 15 lines]
> > equals a certain value. I.E., column A = dog and column B = brown.
> > Thank you.

Reply to this Message

Rate this thread: