Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I have a question on AVerages
I have a job wherein I need to provide the average of 'walk-ins' against the
number of walk-ins seen that day, then average of # of walk-ins for the week (Monday through Friday) then by the month for each location in real numbers Not percentages. There are 21 locations in all. For example: Cell C7 is the # of walk-ins that came in that day Cell D7 lists the actual number of walk-ins seen that day == what would be the formula that would go in E7? Then how do I tally for the week say in E12 which would show the total number of walkin=seen versus the total number of walk=ins for the week. I am so confused I used the =Average number but when C7 has 10 people and D7 has 9 people seen -- the =Average(C7:d7) returns an average of 7 people seen and that cannot be right... (I stink at this!) LOL Because there is only one number pitted against another number -- for the daily tallly by each location, I don't know how to put in the formula --- Could someone please help me! Thank you. (And then of course I will need help with the summary -- but I would be thrilled to get this going...I have been pulling my hair out. thanks Kat |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I have a question on AVerages
Are you sure you are looking for an average?
Sounds like you want to calculate a percentage in stead. 10 customers seen 9 i.e seen 90% =d7/c7*100 or =d7/c7 formatted as a percentage. -- Next a visit to your hair dresser-- Greetings from New Zealand Bill K "kenneth and kathryn olsen" wrote in message k.net... I have a job wherein I need to provide the average of 'walk-ins' against the number of walk-ins seen that day, then average of # of walk-ins for the week (Monday through Friday) then by the month for each location in real numbers Not percentages. There are 21 locations in all. For example: Cell C7 is the # of walk-ins that came in that day Cell D7 lists the actual number of walk-ins seen that day == what would be the formula that would go in E7? Then how do I tally for the week say in E12 which would show the total number of walkin=seen versus the total number of walk=ins for the week. I am so confused I used the =Average number but when C7 has 10 people and D7 has 9 people seen -- the =Average(C7:d7) returns an average of 7 people seen and that cannot be right... (I stink at this!) LOL Because there is only one number pitted against another number -- for the daily tallly by each location, I don't know how to put in the formula --- Could someone please help me! Thank you. (And then of course I will need help with the summary -- but I would be thrilled to get this going...I have been pulling my hair out. thanks Kat |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I have a question on AVerages
thank you so much for replying and I appreciate the formula -- but I was
told to give 'real numbers' -- 'on average' --- that's what has me so confused! and when I asked I was told again 'average' -- so the question still remains -- how do I get an average from one number - do I divide it into the total visitors for the day? thanks "Bill Kuunders" wrote in message ... Are you sure you are looking for an average? Sounds like you want to calculate a percentage in stead. 10 customers seen 9 i.e seen 90% =d7/c7*100 or =d7/c7 formatted as a percentage. -- Next a visit to your hair dresser-- Greetings from New Zealand Bill K "kenneth and kathryn olsen" wrote in message k.net... I have a job wherein I need to provide the average of 'walk-ins' against the number of walk-ins seen that day, then average of # of walk-ins for the week (Monday through Friday) then by the month for each location in real numbers Not percentages. There are 21 locations in all. For example: Cell C7 is the # of walk-ins that came in that day Cell D7 lists the actual number of walk-ins seen that day == what would be the formula that would go in E7? Then how do I tally for the week say in E12 which would show the total number of walkin=seen versus the total number of walk=ins for the week. I am so confused I used the =Average number but when C7 has 10 people and D7 has 9 people seen -- the =Average(C7:d7) returns an average of 7 people seen and that cannot be right... (I stink at this!) LOL Because there is only one number pitted against another number -- for the daily tallly by each location, I don't know how to put in the formula --- Could someone please help me! Thank you. (And then of course I will need help with the summary -- but I would be thrilled to get this going...I have been pulling my hair out. thanks Kat |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I have a question on AVerages
You would be able to have an average number per day for each week
put the total for the week in C12 and D12 (not really needed for the average at this stage) in cell C13 put =average(C7:C11) which would be the average walkins per day for that week in D13 =average(D7:D11) average walkins seen per day hope that helps don't pull any more hair!!!!!!! -- Greetings from New Zealand Bill K "Ohboy" wrote in message ink.net... thank you so much for replying and I appreciate the formula -- but I was told to give 'real numbers' -- 'on average' --- that's what has me so confused! and when I asked I was told again 'average' -- so the question still remains -- how do I get an average from one number - do I divide it into the total visitors for the day? thanks "Bill Kuunders" wrote in message ... Are you sure you are looking for an average? Sounds like you want to calculate a percentage in stead. 10 customers seen 9 i.e seen 90% =d7/c7*100 or =d7/c7 formatted as a percentage. -- Next a visit to your hair dresser-- Greetings from New Zealand Bill K "kenneth and kathryn olsen" wrote in message k.net... I have a job wherein I need to provide the average of 'walk-ins' against the number of walk-ins seen that day, then average of # of walk-ins for the week (Monday through Friday) then by the month for each location in real numbers Not percentages. There are 21 locations in all. For example: Cell C7 is the # of walk-ins that came in that day Cell D7 lists the actual number of walk-ins seen that day == what would be the formula that would go in E7? Then how do I tally for the week say in E12 which would show the total number of walkin=seen versus the total number of walk=ins for the week. I am so confused I used the =Average number but when C7 has 10 people and D7 has 9 people seen -- the =Average(C7:d7) returns an average of 7 people seen and that cannot be right... (I stink at this!) LOL Because there is only one number pitted against another number -- for the daily tallly by each location, I don't know how to put in the formula --- Could someone please help me! Thank you. (And then of course I will need help with the summary -- but I would be thrilled to get this going...I have been pulling my hair out. thanks Kat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating averages excluding outliers...a question | Excel Worksheet Functions | |||
Calculating basic averages...a question | Excel Worksheet Functions | |||
Benefits many people - Question | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions |