I have a question on AVerages

[kenneth and kathryn olsen]

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

 

[Bill Kuunders]

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

 

[Ohboy]

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]

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!!!!!!!