Forum Discussion
Not sure of what formula to use or the best way to do this
Hi; I am trying to automatically give an average over several work sheets (tabs) but only if there is a value in the cell. So if I have 10 sheets and I have a value in a specific cell on 4 sheets t...
Let’s assume that the 10 sheets are named Jan to Oct. I haven’t tested, but you can try, this formula:
=SUM(‘???’!A4)/
SUMPRODUCT(—(‘???’!A4<>0))
=SUM(‘???’!A4)/
SUMPRODUCT(—(‘???’!A4<>0))