Separating Over/Short Amts.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

If your negative numbers are really numbers formatted as (1234):

Over:

=SUMIF(A1:A20,">0")

Short:

=SUMIF(A1:A20,"<0")

Biff
 
Biff--Genius you are!! I have never seen that function before. It is
exactly what I needed--and simple too.

Thanks
bem
 
Back
Top