K
Karen
Columns of numeric grades are to be averaged, but teacher
wants to choose where quarter averaging begins and ends.
I want to just have them enter beginning/ending column #'s
for each quarter, and feed the cell values into the
AVERAGE funciton, but it does not work.
The row is constantly row 5.
Teacher should only have to enter start and end columns
for each quarter:
(AA) (AB) (AC)
(1) quarter start-column end-column
(2) Q1 B L
(3) Q2 M Z
In other words, scores to be averaged are in row 5,
columns B-Z.
I need to go to the cells in the above table and get the
variable substitution values. In other words, to find what
to average, I need to go to cell AB2 and get the letter B,
and cell AC2 and get the letter L. The substitution should
produce:
=AVERAGE(B2:L2)
I tried the following, but it does not work. I also
=AVERAGE((INDIRECT("AB2"))2
INDIRECT("AC2"))2)
Can anyone help me please?
Thanks!
wants to choose where quarter averaging begins and ends.
I want to just have them enter beginning/ending column #'s
for each quarter, and feed the cell values into the
AVERAGE funciton, but it does not work.
The row is constantly row 5.
Teacher should only have to enter start and end columns
for each quarter:
(AA) (AB) (AC)
(1) quarter start-column end-column
(2) Q1 B L
(3) Q2 M Z
In other words, scores to be averaged are in row 5,
columns B-Z.
I need to go to the cells in the above table and get the
variable substitution values. In other words, to find what
to average, I need to go to cell AB2 and get the letter B,
and cell AC2 and get the letter L. The substitution should
produce:
=AVERAGE(B2:L2)
I tried the following, but it does not work. I also
=AVERAGE((INDIRECT("AB2"))2
INDIRECT("AC2"))2)Can anyone help me please?
Thanks!