Thread
:
Question regarding averaging
View Single Post
#
4
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
Question regarding averaging
One way:
=AVERAGE(IF((MOD(ROW(L11:L59),8)=3)*L11:L59<0,L11 :L59,FALSE))
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"jgcrews" wrote in message
...
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann