I am trying to set up a spreadsheet where the lenght of each call goes in a
column.
I need to the show average call lenght at the bottom of the chart.
As the figures are updated frequently I need a formula that will work out
the average of the data entered. When doing the =SUM(D3:D15)/COUNT(D3:D15),
it is counting the blank cells and giving a very false averge. I have tried
going into the excell advanced options and unticked the box SHOW A ZERO IN
CELLS THAT HAVE A ZERO VALUE.

I would have thought this would be quite easy to do. I am intermediatery at
ecel, or so I thought!

Help would be most greatfull