Hi all,
Sorry if this has been asked before but i couldn't find it anywhere.
I need to average the cells in column J starting at row 62 but ending at a variable cell on lets say sheet1. The amount of cells below 62 needed to be averaged is a know number and is stored on another worksheet named sheet2 A1. for example i might need to average the next 24 cells below row 62 which would be row 86 but this can change, i cant just simply average the whole column either as the data i need is in between two zeros which skew my results and needs to be precise. i have tried using the index function but im not too familiar how it works and cant seem to find anyway to be able to change the amount of cells averaged.
thanks in advance.
EDIT: attachment Book2.xlsx
Bookmarks