Formula for Average

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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"
 
Back
Top