AVERAGE

[Marvin]

I'm trying to average the last five numbers in a row but
sometimes a column or two may be blank.

day1 day2 day3 day4 day5 avg day6 day7 day8 day9 day10 avg
1 2
43 43 38 41 43 41.6 41 43 38 35

My formula
=average(B1,B2,B3,B4,B5) for avg1
=average(B7,B8,B9,B10,B11) for avg2

I need the avg2 and subsequent avg's to use the last
five columns with data. So in this example it would
include day10,day8,day7,day6,day5 but each row may
require different columns. With 120 rows of data
changing the avg2 formula for each row is a pain.

Thanks in advance
Marvin

 

[DHymel]

Avg1 = avergae(a2:e2)
Avg2 = average(g2:k2)

the average function will ingore blanks or text as long as
the blank is not 0. If a 0 is present, it will be
included in the average.

 

[Marvin]

-----Original Message-----
Avg1 = avergae(a2:e2)
Avg2 = average(g2:k2)

the average function will ingore blanks or text as long as
the blank is not 0. If a 0 is present, it will be
included in the average.

Your response doesn't help me get the Last FIVE
columns that I need. In my example I would want to
use E2 G2 H2 I2 K2 for this row, the next row could
be something different. I want to ignore all blank
columns and use just the last last five columns in
that row. Your formulas do the same thing as mine.