View Single Post
  #1   Report Post  
bem
 
Posts: n/a
Default Separating Over/Short Amts.

I have a spreadsheet that compares daily sales with money received. The last
column calculates whether the cash register was "over" or "short" for that
day. I would like to add separate cells to total the "over"/"short" amount
for the month. How could I do this?

Ex:
Over/Short
(2.50)
(.75)
1.00

O.K.--The total over/short is ($2.25). But what I need is:
Total Over: 1.00
Total Short: (3.25)

This seems as if it should be simple to do--unfortunately not simple enough
for me to figure out. Any help would be greatly appreciated. Thanks.