Count if help

[Imran Azam]

HI Guys

i heave created a count if formula and i need to makes an adjustment to this so it excluded anything in d2:d8 that contains the word "Ons"

the below formula does work as its looking for the work Ons.

=COUNTIFS(A2:A8, "A", C2:C8, "<>" & "Sales", D2:D8, <> "Ons")

can this be done?

 

[steve the fish]

Try a wildcard:

=COUNTIFS(A2:A8,"A",C2:C8,"<>Sales",D2:D8,"<>*Ons*")