So I have the challenge of getting an average if disjointed cells. I thought I'd be tricking Excel into this by creating a Named Range for my values:
numbers
1 (-MyRange
(blank)
2 (-MyRange
(blank)
3 (-MyRange
(blank)
4 (-MyRange
(blank)
5 (-MyRange
(blank)
0 (-MyRange
When I do the formula:
=AVERAGE(If(MyRange>0,MyRange))
I get #VALUE!
but:
=AVERAGE(MyRange)
returns a number.
I hope this makes sense.
Thanks!
numbers
1 (-MyRange
(blank)
2 (-MyRange
(blank)
3 (-MyRange
(blank)
4 (-MyRange
(blank)
5 (-MyRange
(blank)
0 (-MyRange
When I do the formula:
=AVERAGE(If(MyRange>0,MyRange))
I get #VALUE!
but:
=AVERAGE(MyRange)
returns a number.
I hope this makes sense.
Thanks!