If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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(D711) 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Trying to email a Snapshot File via Macro. ERROR: "The formats . | titlepusher | General Discussion | 5 | November 10th, 2005 03:53 AM |
Question about reducing number of tables in a database | tlyczko | Database Design | 0 | October 27th, 2005 04:15 PM |
Search my question lost in the long list | Shrikant | General Discussion | 3 | August 26th, 2005 09:32 AM |
database design question | e-mid | Database Design | 9 | June 16th, 2004 09:42 PM |
Designing a question paper | Ken | New Users | 2 | April 28th, 2004 10:13 PM |