Cell C8

=SUMIF('[Statistics.xlsx]Male Stats'!B$5:B$9999,$A8,'[Statistics.xlsx]Male Stats'!$D$5:$D$9999)+SUMIF('[Statistics.xlsx]Female Stats'!B$5:B$9999,$A8,'[Statistics.xlsx]Female Stats'!$D$5:$D$9999)

I want to update it look into cell B8 and if cell B8 = ABS or DUM to return a zero in cell C8

If B8 is blank then return a number from the formula above.

Thanks