Thread
:
How to omit blank cells when calculating weighted averages
View Single Post
#
19
October 30th, 2008, 08:19 PM posted to microsoft.public.excel.worksheet.functions
Suzy
external usenet poster
Posts: 39
How to omit blank cells when calculating weighted averages
Thanks so much!!
Suzy
"David Biddulph" wrote:
Yes. That's why I included =AVERAGE(D4
24) as one of my 2 suggestions.
And for further information you could try hitting the F1 key and typing the
word Average.
RTFM doesn't have to be the *last* resort.
--
David Biddulph
"Suzy" wrote in message
...
Hi David,
AVERAGE omits the blank cells, right?
Thanks,
Suzy
"David Biddulph" wrote:
Have you tried =SUM(D4
24)/COUNT(D4
24) or =AVERAGE(D4
24) ?
--
David Biddulph
"Suzy" wrote in message
...
Hi Tom,
Can you help me with another formula? I am also calculating the
averages
of
each particular assignment in the class. How do I omit the blank cells
from
the class average for the assignment?
The formula is:
=SUM(D4
24)/21
Thanks!!
Suzy
"TomPl" wrote:
The formula will work equally as well with percentages as with credits
so
I
think it should do what you asked.
Good luck with it.
Tom
Suzy
View Public Profile
View message headers
Find all posts by Suzy
Find all threads started by Suzy