View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
justaguyfromky justaguyfromky is offline
external usenet poster
 
Posts: 43
Default Need formula for calculating totals to range by using multiple

A slot is just a cell, cash drains are done after heavy periods of cash
volume, or when a cashier is changed on a drawer

for example

cell 1 cell 2
emp 1 -3.25
emp 2 +1.75
emp 2 -0.50

What I want it to do is to add the totals for each employee and keep a
running total of the cash for the week
"David" wrote:

What do you mean by a slot? Is this a time increment?

"justaguyfromky" wrote:

I dont even know how to explain this problem but here goes...

I have a chart that I am trying to track cash shortages I have 15 slots per
day, all 15 slots may not be used every day, but it has just two columns per
day, one for the employee name and one for the cash over/short. I have 3
registers that may have someone assigned to them. I do daily cash drains up
to 5 times per day, all registers may not be used every day. I generally
have anywhere from 10 to 15 employees that may be assigned to these registers
on different times throughout the day and week.

How can I get the totals to automatically add the cash over/short to total
up on a master list of all the employees cash totals and keep a running total
for the week?

Any help would be appreciated

Thanks