champchamp
New Member
- Joined
- Jan 22, 2020
- Messages
- 6
- Office Version
- 2016
I have a column like this
Red Ferrari Blue Red Ferrari
Blue Ferrari Yellow
Yellow Ferrarired
Red Lambo Red
I want to scan through the whole column and count the cells that contain BOTH words "ferrari" and "red" regardless of where they are.
So in this case the count should be 2 (first and third rows are the only ones containing both words regardless of how many times these words occur).
What i tried so far was :
=SUM(COUNTIF(A:A,{"red","ferrari"}))
However this gives a sum of all occurances and not the number of cells.
Red Ferrari Blue Red Ferrari
Blue Ferrari Yellow
Yellow Ferrarired
Red Lambo Red
I want to scan through the whole column and count the cells that contain BOTH words "ferrari" and "red" regardless of where they are.
So in this case the count should be 2 (first and third rows are the only ones containing both words regardless of how many times these words occur).
What i tried so far was :
=SUM(COUNTIF(A:A,{"red","ferrari"}))
However this gives a sum of all occurances and not the number of cells.