H
hs
Hi,
I'm trying to average a range except one cell in the middle of that range
(or alternatively to condition on a range made of two separate sections). The
formula I'm trying to use is the following:
=IF(AND(B$47>0, B$53=2), B$47-AVERAGEIF(B$45:B$50, ">0"), "-")
Except, instead of B45:B50 in AVERAGEIF, I want the range to be B45:B46 and
B48:B50 (i.e. without the cell B47).
Can anyone tell me how to use a split range with AVERAGEIF or how to tell it
not to look at cell B47?
Grateful for any advice. Thanks!
I'm trying to average a range except one cell in the middle of that range
(or alternatively to condition on a range made of two separate sections). The
formula I'm trying to use is the following:
=IF(AND(B$47>0, B$53=2), B$47-AVERAGEIF(B$45:B$50, ">0"), "-")
Except, instead of B45:B50 in AVERAGEIF, I want the range to be B45:B46 and
B48:B50 (i.e. without the cell B47).
Can anyone tell me how to use a split range with AVERAGEIF or how to tell it
not to look at cell B47?
Grateful for any advice. Thanks!