B
bsk
I'm doing a series of mean calulations for one set of cells based on a
entries in another set of cells. Here's an example:
=AVERAGE(IF($I$3:$I$23>=4,$L$3:$L$23))
I have about 10 of these formulas for rows 3 to 23.
If I need to do the formula for rows 40 to 45, I can't simply copy and
paste the formula, because the rows will adjust to the wrong rows.
Right now, I am manually changing the range for all 10 formulas.
How do I create some type of shortcut, so I don't have to manually
change the range 10 times, when new range is larger or shorter than the
old range?
entries in another set of cells. Here's an example:
=AVERAGE(IF($I$3:$I$23>=4,$L$3:$L$23))
I have about 10 of these formulas for rows 3 to 23.
If I need to do the formula for rows 40 to 45, I can't simply copy and
paste the formula, because the rows will adjust to the wrong rows.
Right now, I am manually changing the range for all 10 formulas.
How do I create some type of shortcut, so I don't have to manually
change the range 10 times, when new range is larger or shorter than the
old range?