Thread
:
Question regarding averaging
View Single Post
#
7
Posted to microsoft.public.excel.misc
jgcrews
external usenet poster
Posts: 4
Question regarding averaging
Sandy:
I tried your suggestion and ended up with "#Value!" instead of an average.
I then tried Mike's suggestion and it worked OK.
Me and my diabetes thank you both for your help!
Jeff
"Sandy Mann" wrote:
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
jgcrews
View Public Profile
Find all posts by jgcrews