Excel - COUNTIF Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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))
 
Thank you very much RagDyer. That works.
jsk

RagDyer said:
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))
Click to expand...
 
Back
Top