J
jgcrews
I'm a relative novice and have a straight-forward question concerning
averaging. I need to average a specific set of cells (not a continuous
range) and ignore any cells with a value of 0.
I'm sure this is pretty easy but the more I read about all of the averaging
functions, the more confused I got.
Currently, I'm simply using:
=AVERAGE(L11,L19,L27,L35,L43,L51,L59)
which obviously isn't what I really want.
Can someone head me in the right direction? Thanks in advance for your help.
Jeff
averaging. I need to average a specific set of cells (not a continuous
range) and ignore any cells with a value of 0.
I'm sure this is pretty easy but the more I read about all of the averaging
functions, the more confused I got.
Currently, I'm simply using:
=AVERAGE(L11,L19,L27,L35,L43,L51,L59)
which obviously isn't what I really want.
Can someone head me in the right direction? Thanks in advance for your help.
Jeff