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
Bookmarks