Hey all I using this formula in
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
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