# add and subract in one sum

1. ## add and subract in one sum

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

2. ## Re: add and subract in one sum

why not put 10 to start and then use -1 -3
then =sum(

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"k1ngy" <k1ngy@discussions.microsoft.com> wrote in message
news:2C8CAFE8-D439-49C8-A05C-91E54BE45890@microsoft.com...
>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

3. Can you post an example of the data.

I think you should be able to use a sumif statement if you want to sum all the delivery's on a Mon for example.

e.g =SUMIF(A:A,"Mon",B:B)

4. ## Re: 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...

=SUM(A2:AE2)
For the entire month.

--

HTH,

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

"k1ngy" <k1ngy@discussions.microsoft.com> wrote in message
news:2C8CAFE8-D439-49C8-A05C-91E54BE45890@microsoft.com...
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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1