formula to count number of two different non-numeric responses
=COUNTIF(A1:A20,"YES")
=COUNTIF(A1:A20,"NA")
--
Gary''s Student - gsnu200774
"cookie's mom" wrote:
having trouble with this - need help on what formula to count the total of
two different non-numeric values in a range, i.e., "Yes" and "NA" - trying
COUNTIF, but having trouble...
|