M
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
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