I can't seem to find the specific answer to my issue regarding finding the minimum value, excluding zeroes ranging across multiple sheets and multiple cells in each sheet. The sheet names are the months of the year with the last two digits of the year.
I've tried the below formula coming up with a #ref! issue:
=MIN(IF('January 22:December 22'!O2:O32<>0, 'January 22:December 22'!O2:O32))
Can anyone help me with what I'm doing wrong.
I've tried the below formula coming up with a #ref! issue:
=MIN(IF('January 22:December 22'!O2:O32<>0, 'January 22:December 22'!O2:O32))
Can anyone help me with what I'm doing wrong.