Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default adding values from 2 columns

I am trying to compose a personal cash flow chart where I can enter outgoings
and income for every day of the month and see what the balance is on any day.
I need to get a value in Col F which adds the value in Col C (daily income),
subtracts the value in Col E (daily outgoings) and shows the balance.
Also I may have to specify several rows if I have multiple outgoings on a
particular day.
Any ideas gratefully received.
Gaby
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 89
Default Subject: adding values from 2 columns

Sounds like you want a checkbook register.

Something like this?
A B C D E
Start Bal $1,023.32
Date Item Expense Deposit Balance
$10.12 $1,013.20
$23.32 $989.88
$9.95 $100.00 $1,079.93

The formula in column E:
=IF(C4+D4=0,"",$E$2-SUM($C$4:C4)+SUM($D$4:D4))

The formula starts with the Starting Balance and subtracts the sum of all of
the Expenses, then adds the sum of all of the Deposits.
Ths Sum function uses a combination of Abolute and Referential referencing
to allow the Sum range to grow as you copy it down the page.
The If statement checks to see if Both column C and column D are zero, if
they are it prints a blank in the cell, if either one has a value greater
than zero then it calculates the sum.

Mike


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding values from adjacent columns DJ Excel Discussion (Misc queries) 2 November 18th 08 11:33 AM
macro or function help needed for adding columns for values missin Arain Excel Discussion (Misc queries) 10 May 17th 07 12:46 AM
Adding values in columns with a specific indicator [email protected] Excel Worksheet Functions 3 April 30th 07 12:04 PM
Adding numerical values based on multiple values in another column Kazmaniac Excel Worksheet Functions 6 April 4th 07 08:53 PM
Adding values within multiply columns Scott@CW Excel Discussion (Misc queries) 4 January 16th 07 08:54 PM


All times are GMT +1. The time now is 12:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"