a countif statement with multiple conditions
 

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

a countif statement with multiple conditions
 

try
=sumproduct((a2:a22="ace")*(b2:b22={"club","diamon d","spade"}))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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