"sandres74" wrote:
=AVERAGE(E7:E126,M7:M129,U7:U128)
[....]
The problem is that I need the formula to ignore
blank cells and cells that contain a zero.

If read look at Excel Help, you would see that AVERAGE already ignores blank
cells, even cells that contain null and blank strings as well as other text.
So the only thing you need to worry about are cells whose value is zero.

Try the following array formula[*]:

=AVERAGE(IF(E7:E126<0,E7:E126),
IF(M7:M129<0,M7:M129),
IF(U7:U128<0,U7:U128))
[*] An array formula is commited by pressing ctrl+shift+Enter instead of
just Enter. You will see the entire formula surrounded by curly braces in
the Formula Bar, viz. {=formula}. If you make a mistake, press F2, edit the
formula if necessary, then press ctrl+shift+Enter.


----- original message ----

"sandres74" wrote:
I have the following formula - which works - to calculate an average of
numbers that are listed in 3 separate columns:
=AVERAGE(E7:E126,M7:M129,U7:U128)

The problem is that I need the formula to ignore blank cells and cells that
contain a zero. I've tried many different things but just can't get it to
work!

Anyone have any suggestions?
Thanks in advance for your help!