I am trying to take the average of certain cells in four different sheets. For example, each sheet represents a week and the summary sheet totals the four weeks. The sheets are identical. One sheet takes an average of each day of the week, however, my columns are not contiguous for the range I want to average. Therefore, I need the formula to average the week. Then I need the formula on the summary sheet to average all four weeks. I do not want to average blank cells. I have researched this issue on the web for a couple of hours and have tried various different formulas. I can figure out one sheet and one week but not how to average the four weeks. Any help???
Bookmarks