Nested countif,or

[letsrolldog]

I am having trouble writing a nested function. I want a range of cells (A1 to
D1) to be counted if they contain the letter X or C.

Thank you.

 

[Fred Smith]

How about:

=countif(a1:d1,"X")+countif(a1:d1,"C")

Regards,
Fred.

 

[Dave Peterson]

One more:

=SUM(COUNTIF(A11,{"X","C"}))

I am having trouble writing a nested function. I want a range of cells (A1 to
D1) to be counted if they contain the letter X or C.

Thank you.