Formula for Average

[Guest]

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.

 

[Guest]

The AVERAGE() function by default doesn't count blank cells when calculating.

 

[Roger Govier]

Hi

The Average function ignores Blank cells, as opposed to values with 0 in
them.
i.e. the count of values to use as the divisor for the average
calculation does not get incremented if the cell is blank.

Regards

Roger Govier

 

[Guest]

Thank you so much for your answers, sometimes you get so caught up in the
complicated side of things that you forget how simple others can be. "sigh"