Hi Arlen

In a worksheet, use the function COUNTA which counts the
non-empty cells only. It is also accessible from VBA through:

Application.WorksheetFunctions.CountA(...)


Cheers,
Martin

"Arlen" schrieb im Newsbeitrag
...
I couldn't really find any perfect fit to this question as
far back as two months ago, so I'm re-pooping the question.

I am trying to keep a month-long running average of a
dentist's daily production. Obviously, the number should
not factor in the days we do not work. The $ total is
easy enough, but how do I tell Excel to scan a 31-day
range, and only divide by the number of days with figures
in them?

Thanks so much for all your help, people.

Arlen