Exclude word from countif formula

[rayted]

Hi guys,

If cell A2 has this written: "Adhoc - Task 1" how can I write a countif formula like this:

=COUNTIF('Test Spreadsheet'!$A$2:$A$20, "On Hold", <>"Adhoc*") - basically do not count cells that include the word Adhoc.... I want to count the cells that say on Hold in B2 onwards except cells with the word: Adhoc as part of the cells

[davsth]

I assume you know that * include strings with anything before or after depending where it is placed
=COUNTIFS('Test Spreadsheet'!A1:A20,"*On hold*",'Test Spreadsheet'!A1:A20,"<>*adhoc*") may be along the lines of what you want

[rayted]

thank you this works!