I got a sheet whcih need user to input pass,fail or NA.
and i need to have a summary.
to count "P"
=COUNTIF(D4:D99,"P")
but i don;t know the formula to count all the condition,(P,F,NA)
i wich to use count formula instead of SUM. to avoid if user forget to input any (P,F,NA) result.
see attached file
Bookmarks