Im trying to get the average of data from 5 other sheets with
=AVERAGE('Period 1'!L4:L43,'Period 2'!L4:L43,'Period 3'!L4:L43,'Period 4'!L4:L43,'Period 5'!L4:L43)
the cells I want to find the average of (L4:L43......etc.) contain the "LN" function referencing the cell to their left, eg. L4 = LN(K4)
so i get a #NUM error in the cell containing
=AVERAGE('Period 1'!L4:L43,'Period 2'!L4:L43,'Period 3'!L4:L43,'Period 4'!L4:L43,'Period 5'!L4:L43)
Is there a way I can adjust this formula to work out the average rather than give #NUM error?
Thanks
Bookmarks