I have a table with columns Mon-Fri and Rows for Week 1-5. In the cells I
will be entering general numbers.

My last row contains the formula to average the columns for Mon-Fri for
weeks 1-5. But my problem is, For my November data, we do have a week 5, but
only for Sun-Wed. What happens with my data on row 5 for Thur-Sat, where I
dont have any data, I dont want my formula to average the blank cells.

I welcome anyone who would be willing to let me send them an attachment as I
dont think I have explained myself well.