N/A comes when the data range you have used has incorrect or invalid input. Try the IF range or COUNTIF range for pulling up the data ranges.

Excel returns these errors when an ... #N/A errors are encountered when Excel cannot find a match for the value it ... 's been told to find and it displays that message ...
