This should be a very simple maths question...

[subbytna]

2250

lol

not the total...average

 

[Bleek]

What version of Excel do you use?

In 2007 & 2010 you only have to highlight the range and it'll show you the average, count and sum in the footer.

Average - 225
Count - 20
Sum - 4500

I'm stuck on 2002. I think it might do that though.

I have shiny Windows 7 and Office 2010 CDs sat here including new HDDs, just not had time to get it all installed... I'm hanging on to XP with nostalgia fuelled rage!