Jul 20 2020 10:53 AM
Jul 20 2020 11:03 AM
You could try surrounding whatever formula you have that is working when there are no #N/A errors....surround that existing formula with the IFERROR function. It will end up looking something like this:
=IFERROR(whatever_you_have_already),0)
That should put a zero in instead of #N/A
If you'd rather a blank space, then
=IFERROR(whatever_you_have_already),"")
If that doesn't make sense, or doesn't work, perhaps you could post a copy of your sheet, just devoid of real names or any other confidential info.