The result for this is either a zero or a numerical value > 1. I am trying to replace the zero with a blank. However when I do calculations it gives me an error. How can I use this and turn the blank into a calculable result. Thanks for the help.
=IF(COUNTIF('TRKLD SCHED'!$V$1:$BC$1,A13),HLOOKUP(A13,'TRKLD SCHED'!$V$1:$BC$113,107,0),"0")+IF(COUNTIF('TRKLD SCHED'!$D$1:$N$1,A13),HLOOKUP(A13,'TRKLD SCHED'!$D$1:$N$113,107,0),"0")
=IF(COUNTIF('TRKLD SCHED'!$V$1:$BC$1,A13),HLOOKUP(A13,'TRKLD SCHED'!$V$1:$BC$113,107,0),"0")+IF(COUNTIF('TRKLD SCHED'!$D$1:$N$1,A13),HLOOKUP(A13,'TRKLD SCHED'!$D$1:$N$113,107,0),"0")