M
marvin
This is a repost that is hopefully clearer about what I'm
trying to accomplish.
I'm trying to average the last five columns in a row that
have a value. I must always have five(5)values to average
zero or blank must be skipped .
A B C D E F G H I J K L
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
38 39 37 39 37 38 36 38 39
The formulas I'm using at this time;
=average(A2,B2,C2,D2,E2) for avg1
=average(G2,H2,I2,J2,K2) for avg2 (I must change formula
for each row if the desiginated columns are blank)
Using the above formula for avg2 means for each row I have
to change the formula to use the last five (5) columns
with actual data. What I need is a formula that would know
to use(k2,i2,h2,g2,e2) for the first example and
(k2,J2,G2,E2,D2)for the second example.
I need the avg2 and subsequent avg's formulas to use
the last five (5) columns with data.
With 120 rows of data changing the avg2 formula for
each row is a pain.
Thanks in advance
Marvin
trying to accomplish.
I'm trying to average the last five columns in a row that
have a value. I must always have five(5)values to average
zero or blank must be skipped .
A B C D E F G H I J K L
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
38 39 37 39 37 38 36 38 39
The formulas I'm using at this time;
=average(A2,B2,C2,D2,E2) for avg1
=average(G2,H2,I2,J2,K2) for avg2 (I must change formula
for each row if the desiginated columns are blank)
Using the above formula for avg2 means for each row I have
to change the formula to use the last five (5) columns
with actual data. What I need is a formula that would know
to use(k2,i2,h2,g2,e2) for the first example and
(k2,J2,G2,E2,D2)for the second example.
I need the avg2 and subsequent avg's formulas to use
the last five (5) columns with data.
With 120 rows of data changing the avg2 formula for
each row is a pain.
Thanks in advance
Marvin