a countif statement with multiple conditions

perfect_one1 · Oct 30, 2008

countif cell a=ace and cell b=club, diamond, or spade. this is in a very
large spreadsheet

Don Guillett · Oct 30, 2008

try
=sumproduct((a2:a22="ace")*(b2:b22={"club","diamond","spade"}))