A function to split cash and credit card purchases.

I need a function that "splits" a total when I have a row that has an entry called "S" for split. For example...I need a way for an Excel function to separate the amount alotted to a purchased item when I pay half cash and half credit. For instance, let's say I purchase a camera for 100 dollars. After entering the date, type of purchase all on one row, in one specfic row I enter "S" for split...which should tell the Excel function to take the credit part of the purchase and put it in another row as an added total of credit card debt. In one row I would enter the cash amount and in the other row I enter the credit amount. When I enter the "S" signifier in the next row, the function looks at the "S" and immediately looks in the credit row and takes that amount and totals the credit amount to a specific running total.

A1 = Date
B1 = Purchased Item (text value)
C1 = Total Cost (numeric value)
D1 = Cash Amount
E1 = Credit Amount
F1 = Signifier "S"
GI = Function assigned to look at the value in F1. =if(F1="s",c1-d1,"")
H1= +G1.

Any future purchases which require a split...I need the function to add the running total into H1 so I have a total amount of credit card debt payment listed.

Any ideas? Thanks in advance.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!