dynamic averaging

  • Thread starter Thread starter jimmy
  • Start date Start date
J

jimmy

I have 12 columns in which each column only has one used
cell. each column represents a month of the year, and
each cell represents a certain percentage for something
done in that month. what i want to do is at the end of
the 12 columns is be able to average the months together.
i want to have a formula that will take this average
throughout the year. for instance in july when only 7
months have values and 5 months have null, the formula
only average the 7 months with values, and then when an
8th month is entered for the formula to automaticallly
recognize the 8th month value and take an average for 8
months. Thanks a lot for all your help (in advance of
course)
 
If the option is either a value or null you can use

=AVERAGE(A2:L2)

(adapt to fit your range)

since it will ignore text or blanks.
 
Back
Top