COUNTIF

  • Thread starter Thread starter Lacy
  • Start date Start date
L

Lacy

I'm trying to use COUNTIF, but I have three different
criteria, each in a different column. Does anyone know of
a way to do this? Thanks for the help.

Lacy
 
You can do something like this:

This will count how many times there is a match of all
three in the same row.
=Sum((A1:A100=Criterion1)*(B1:B100=Criterion2)*
(C1:C100=Criterion3))

This will count how cells in Range D, when there are three
matches.
=Count(If((A1:A100=Criterion1)*(B1:B100=Criterion2)*
(C1:C100=Criterion3),(D1:D100),""))

Both of these are Array Formulas, so you'll have to use
Ctrl+Shift+Enter to enter them, instead of just Enter.

tod
 
Back
Top