"L/P" wrote in message
...
Need to add a column that has either a "P" or an "X". I can figure out how
to add "p's" or "x's"( =COUNTIF(D2:D65,"p") but not both ("p and/or x").
It was suggested I use the countif.

Err,

=COUNTIF(D2:D65,"p")+COUNTIF(D2:D65,"x")

, ?

HTH,
Andy