View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR
 
Posts: n/a
Default add and subract in one sum

Just enter negative numbers in the columns when they are used.

Say that:
A2 Mon = 10
B2 Tues = -1
C2 Wed = -1
D2 Thurs = 3
E2 Fri = -1
F2 etc...

And your formula is:
=SUM(A2:AE2)
For the entire month.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"k1ngy" wrote in message
...
I have a worksheet that has balances for delivery and usage. they are all on
one line and a want a monthly use at the end. so 10 delivered mon 1 used
tues
1 wed 3 del thurs 1 used friday. Each day being a different column. how
would
my sum look please?