I would like to use a sumif formula with not equalt to a certain word and I know one can use a trumpcard (or special character) to do this. What are all the trumpcards in excel?

Hi Minaar

Thank you for your question.

The trump cards, or wildcards as they are more commonly known, are ? (question mark) for a single character, e.g. organi?ation will find organisation and organization; and * (asterisk) for multiple characters, e.g. org* would find organise, organize, organising, organizing, organisation, organization and anything else that started with the letters org.

I hope this helps.
Amanda