Count cells in a range that are NOT blank and are NOT "N/A"

[russoagain]

Hello,

I need help creating the proper formula in the attached screenshot. The formula needs to look at the cells in column Z and column AC and it needs to countif the cells in the range are NOT blank and DO NOT equal "N/A".

Can someone please help with this?Capture.PNG

[ORoos]

Hi russoagain,
Try for column N: =COUNTA(Z2:Z500)-COUNTIF(Z:Z,"N/A")
First part of the formula is counting all cells which are not blank. Start on row 2 to exclude header. The second part is deducting the number of cells with contain "N/A".
Replicate with relevant ranges for column AC.

[davsth]

in the above it depends if the n/a is a result of a formula and so #n/a with no quotation marks