Thread: CountIf
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default CountIf

=COUNTIF(data;"Word 1")+COUNTIF(data;"word2")

One way (data is your range)

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Wendy" wrote in message .. .
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