ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   CountIf (https://www.excelbanter.com/excel-programming/271176-re-countif.html)

Ron de Bruin

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






All times are GMT +1. The time now is 04:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com