Forum Discussion
Averaging non-adjacent cells with earlier errors
I'm an Excel newbie and have been butting my head against the wall. Not sure where the problem is, so have attached the spreadsheet. The explanation for the spreadsheet is below. My question is ...
I suggest that you manually enter your desired results, with an explanation of how you arrived at each of those results. Thereafter, I will analyze such results and recommend the formulas you need for each of them. Most importantly, please modify the layout of your data by unmerging all data cells.