Forum Discussion
Counting within columns
apple banana peach apple apple orange grapes apple banana orange apple peach apple apple grapes banana banana apple For a chart like the abo...
=COUNT(SEARCH("apple",A1:A8&B1:B8&C1:C8)*(SEARCH("banana",A1:A8&B1:B8&C1:C8)))
Maybe with above formula. Enter formula as arrayformula with ctrl+shift+enter if you don't work with Office365 or 2021.