Counting the Number of Ocurrances

[AnnieGr]

Hi

I have a column that has a list of dates and words etc. What I would like to do is for Excel to Count the number of times the word "cancelled" appears. Watching you tube videos it only seems to show if its just one word, which is east. My criteria is

CANCELLED on ROUTE
CANCELLED on SITE

Which means there are two Occurrences, because all I would like it to look at is CANCELLED

The formula I have used is =COUNTIFS('[Generator Daily Data 19.01.2019.xlsx]SUPPLIER TEMPLATE'!$Q$11:$Q$164, "CANCELLED") and it keeps throwing back "0" when I know there are 17

As you can see I am very novice at this and wondered if anyone can help

Thank you

 

[gaz_chops]

Welcome to Mr Excel,

Try

=COUNTIFS('[Generator Daily Data 19.01.2019.xlsx]SUPPLIER TEMPLATE'!$Q$11:$Q$164, "*CANCELLED*")

 

[AnnieGr]

Holy moley thats worked! Thank you so much, been looking for hours today to sort it out. Easy when you know how

 

[gaz_chops]

lol you're welcome