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.

How about:

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

Regards,
Fred.

"letsrolldog" wrote in message
...
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.

One mo

=SUM(COUNTIF(A1:D1,{"X","C"}))


letsrolldog wrote:

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.

--

Dave Peterson