Need help using multiple criteria in second argument of CountIfs function

Need to use CountIFs formula to evaluate multiple conditions in the same column. Here is the formula I tried. It works for Resolved but returns 0 when i try to add Duplicate.
=COUNTIFS('P12 Source'!H:H,A18,'P12 Source'!F:F,"Resolved,duplicate")
Also used this formula with success by referencing a cell that had "Resolved" in it but when I tried to add another cell with "Duplicate" it again returnded 0.
=COUNTIFS('P12 Source'!$H:$H,A19,'P12 Source'!$F:$F,'P12 Source'!$F$75)

Try

=SUM(COUNTIFS('P12 Source'!H:H,A18,'P12 Source'!F:F,{"Resolved,duplicate"}))


to use 2 cells, say F75=Resolved and F76-duplicate
=SUMPRODUCT(COUNTIFS('P12 Source'!H:H,A18,'P12 Source'!F:F,F75:F76))

Jommo1, Thanks for the reply. I tried both and they both returned "False" rather than a Count.

Good catch on the quote markes..
Definately makes a big difference.

Originally Posted by XOR LX

=SUM(COUNTIFS('P12 Source'!H:H,A18,'P12 Source'!F:F,{"Resolved","duplicate"}))

Thank you both for the replies. Used the newly suggested formula but still get "False" as opposed to zeroing out or giving me the count. The colunm I am trying to evaluate has the following text choices in the cells Closed, Resolved, Duplicate, Rejected, Pending, Assigned and Work In Progress.

Are you actually seeing the word "False", or are you getting 0 and interpraiting that as false?

Can you post a sample book?