I want to return a count of how many times the word FREE appears in a column (column B) which is tied to a style code (column E)
I've attempted different iterations of each formula below to no avail:
=countif($B$2:$B$1000,"*"&"FREE"&"*")- wildcards used to account for other characters in the string.
The problem I am having is that I am unsure of how to link column E (unique style code) to column C, then return how many times FREE appears (column B) per style in C.
Any help is greatly appreciated.excelexcel-formulavlookupcountif
Can you upload the excel or provide screenshot ? It appears that there are two solutions to this. Either you can use VBA with InSTR command. With formula you can use =FIND(cell). if it returns a value, it means it exisits and if it throws an error it means it does not exisit. Then you can sum it up.
I recommend adding a new column that represents whether "FREE" is present in the B column:
Then you can
COUNTIFS on the new column equaling TRUE, and the style codes