Need formula for dividing by "number of entries" in a column or row

[timothy]

Hello there,

I am seeking a formula that will divide by the actual number of
entries in a row or column. For example, if I want the running
average of "requests for service" on Mondays in a year, but I am only
in week 27, then I can't very well get that figure by dividing by 52
weeks, I need a formula that totals the actual "number of entries" in
the row or column and uses that figure to divide the total number of
"requests for service" of all Mondays so far.

I would greatly appreciate any assistance with this problem.

Thanks,
Tim

 

[Bernard Liengme]

If I have numbers in A1:A4, then =AVERAGE(A1:A4) gives me the average
But =AVERAGE(A1:A100) gives the same value if A5:A100 are empty (or hold
non-numeric entries)

To answer the question, as posed: =COUNT(A1:A100) will tell you how many
numeric values are in A1:A100

best wishes from Nova Scotia

 

[Ron Coderre]

Can you help us a bit by posting the general row/column structure?

Example:
Row_1 contains dates beginning in cell B2
Col_A contains Company Names
etc

Meanwhile....here's something that may get you pointed in the right
direction...
This formula counts the number of Mondays in A1:A20
=SUMPRODUCT(--(WEEKDAY(A1:A20)=2))

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[timothy]

Thank you so much Bernard! That worked quite well.

Farewell to Nova Scotia from the Big Smoke

Tim