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