Another Excel query

AHarvey · 14 Nov 2008 at 14:10

Hi all,

Need some more help with excel.

I have a column of 6 objectives, each gets scored out of 5. However, not each one will be scored every time we do a review.

At the bottom I need to add up all of the scores and then divide by how many entries in the column.

So I can't just do =sum((B3:B8)/6), I need to do =sum((B3:B8)/X) where X is the number of objectives reviewed.

Is this possible?

Poolybit · 14 Nov 2008 at 14:19

You could try doing a mix between count and sum functions...such as:

=SUM(B3:B8)/(COUNT(B3:B8))

That should divide the total of B3:B8 by the number of populated cells...Should anyway..

Participant · 14 Nov 2008 at 14:20

=AVERAGE should ignore blank cells.

AHarvey · 14 Nov 2008 at 14:51

Poolybit said:
You could try doing a mix between count and sum functions...such as:

=SUM(B3:B8)/(COUNT(B3:B8))

That should divide the total of B3:B8 by the number of populated cells...Should anyway..

Worked a treat

Thanks!