Hi,

A cell can't contain the exact value "sales" and the exact value "marketing", so your COUNTIFS() formula returns 0.

Assuming you want to count the cells in A1:A12 which are "sales" OR "marketing" you can do it like this:

=COUNTIF(A1:A12,"sales")+COUNTIF(A1:A12,"marketing ")

or

=SUM(COUNTIF(A1:A12,{"sales","marketing"}))

or

=SUMPRODUCT(COUNTIF(A1:A12,B1:B2))
where B1 has the word sales and B2 has the word marketing