A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hello Douglas Hillmer,
You may refer to the AI-generated answer, as the suggested formula is correct for the requirement described:
=COUNTIF(my_range,"NA")
The COUNT function counts cells containing numeric values, while COUNTIF can count cells that meet a specified text condition. In this formula, the asterisks (*) are wildcard characters, so Excel counts any cell containing the consecutive letters NA anywhere within its text.
For example, the following values would be counted:
- XXX: NA
- YYYY: NA
- NA
- Status: NA pending
- BANANA
- Canada
Please note that COUNTIF is not case-sensitive. Therefore, NA, Na, nA, and na are treated as the same text. This is why values such as BANANA and Canada are also counted.
However, a value such as N/A would not be counted because the slash separates the letters N and A, meaning that the cell does not contain the consecutive text NA.
Therefore, in the example shown, the formula returns 6.
Best regards,
If the answer is helpful, please click "Yes". If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in documentation to enable e-mail notifications if you want to receive the related email notification for this thread.