Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula for dividing by "number of entries" in a column or row
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula for dividing by "number of entries" in a column or row
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 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email wrote in message oups.com... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula for dividing by "number of entries" in a column or ro
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 " wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula for dividing by "number of entries" in a column or row
Thank you so much Bernard! That worked quite well.
Farewell to Nova Scotia from the Big Smoke Tim On Apr 5, 10:25 am, "Bernard Liengme" wrote: 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 -- Bernard V Liengmewww.stfx.ca/people/bliengme remove caps from email wrote in message oups.com... 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- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu | Excel Discussion (Misc queries) | |||
Delete the number "49" from each cell in a column | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
FIND is not "finding" a number in a column which contains the numb | Excel Worksheet Functions |