I tried this formula, but am getting 0% with error, the formula in the cell refers to a range that has additional numbers adjacent to it. I tried to select omit adjacent but still 0%

Tab Summary set as percentage
=PRODUCT(IF('Current State'!F2:F50<>0|'Current State'!F2:F50))

Tab Current State
values F2:F21 (has value > 0% 1-100%) and F22:F50 are 0%
100%
75%
50%
25%
75%
50%
25%
100%
75%
50%
100%
75%
50%
25%
75%
50%
25%
100%
75%
50%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%