Goodnight

I come to ask for help with a formula.

I intend that, if there is nothing in B10, then nothing appears.

If there is a number in B10, I want the formula to look for it in Scale April 2023_Cycle count.xls in the Scale tab from cell E7 to K37,

if found, execute the formula, if not found, look for it in Scale April 2023_Cycle count. xls in the Scale Tab in cell AI7 to BZ37,

if found, execute the formula, if not found, look for it in Scale April 2023_Cycle count.xls in the Scale Tab in cell CA7 to CD37,

if not found anywhere, then stay in blank.

=IF(B10="";"";COUNT.IF('[April 2023 scale_Cycle count.xls]Scale'!$E$7:$K$37;B10)/4)

=IF(B10="";"";COUNT.IF('[April 2023 scale_Cycle count.xls]Scale'!$AI$7:$BZ$37;B10)/4)

=IF(B10="";"";COUNT.IF('[April 2023 Scale_Cycle count.xls]Scale'!$CA$7:$CD$37;B10)/4)

These are the three formulas that I intend to unite and become one ... but I am not able to do that.

Could you please help me.

Thanks Compliments