Excel VBA-Personal Budget: Identifying text in a column...
 

Identifying text in a column, reading a sum in the next column an
subtracting that number from a cell with the total.

For instance:
If one of the cells from A2:A10 = "Visa Payment" then subtract (an
here's where I get lost) the sum ($$ payment) from the correlating cel
in column B from a cell with the total.

I have the columns named: Date, Debtor, Payment and Total Due.

Any ideas? I think it's a simple IF, THEN, ELSE formula, but I can'
get my brain around it.

Thanks

--
Message posted from http://www.ExcelForum.com

Excel VBA-Personal Budget: Identifying text in a column...
 

I am not 100% sure where your PreviousTotal Due, Payments and Balance Due
amounts are/should go, but maybe this will help:

CurrentBalance=IF(COUNTIF(A2:A10,"=VisaPayment")0 ,TotalDue-PaymentAmount,To
talDue)

If there has been a VisaPayment, subtract the Payment from the TotalDue,
otherwise return the TotalDue.
--

HTH,

George Nicholson

Remove 'Junk' from return address.


"flotsam2004 " wrote in message
...
Identifying text in a column, reading a sum in the next column and
subtracting that number from a cell with the total.

For instance:
If one of the cells from A2:A10 = "Visa Payment" then subtract (and
here's where I get lost) the sum ($$ payment) from the correlating cell
in column B from a cell with the total.

I have the columns named: Date, Debtor, Payment and Total Due.

Any ideas? I think it's a simple IF, THEN, ELSE formula, but I can't
get my brain around it.

Thanks.


---
Message posted from http://www.ExcelForum.com/

Excel VBA-Personal Budget: Identifying text in a column...
 

Could it be accomplished with an excel formula instead of VBA code

Attachment filename: budget.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=51998
--
Message posted from http://www.ExcelForum.com

Excel VBA-Personal Budget: Identifying text in a column...
 

Attached is the .xls with the suggested formula, but I can't seem to get
it to function properly.

Any other ideas?

Attachment filename: budget.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=520141
---
Message posted from http://www.ExcelForum.com/