CountIf
 

COUNTIF doesn't take only 1 argument.

=SUM(COUNTIF(BA:BA,{"Raised Panel","MDFRaised Panel"})

Alan Beban

Wendy wrote:
How do you count the number of instances in a column that 2 words occur.

For example, in column BA, I want to count the instances of the word "Raised
Panel" and "MDFRaised Panel".

Countif only takes 1 arguement.

Thanks

Wendy