i need to make a spreadsheet that averages numbers. but the amount of cells with data change from a week to week basis. For example i may use cells A1 to A5 to hold data in and A6 with the formula to average. I may use all 5 cells or I may use only 2. How can I tell excel to average those cells that only have data in them.

plz help, thx