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.
![more](/images/more.svg)
Excel returns these errors when an ... hand, #N/A errors are encountered when Excel cannot find a match for the ...
![more](/images/more.svg)