Credit minus daily charge formula

Please, I'm working on this project for my son. His personal trainer,
preparing daily schedule and charges. based on 1 week. I need help with credit minus daily charge formula, I'll explain

for example (John) trains daily for 1hr. x $50.00, but he has credit of $200.00
I want every day charge deducts from the credit he has.

I have this "=IF(C12=""," ",IFERROR(C12*D12-VLOOKUP(B12,Table1,3,FALSE),""))" on Johns daily total charge cell but I realised its deducting same amounts on every day. it doesn't deduct on daily lets say
1st day $50.00 - $200 = $150.00 and second day $50.00 - $150.00= $100.00 and so on.

I hope I managed to explain sorry for long story.

It's difficult (at least for me) to understand the layout of your data without seeing a small representative sample of what you are looking at.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Here you go


Thanks

Correct me if I am wrong but I do not believe that you included your desired results (the bold part of post #2).

Are you looking for a formula to produce values in columns E, K, and Q in the 'november' sheet, column C of the 'students' sheet, or both?

Here what I need is the High-lighted ones below each row

Try this in E4:
=IFERROR(VLOOKUP(B4,Table1,3,FALSE)-SUMIF(B$4:B4,B4,C$4:C4)*VLOOKUP(B4,Table1,2,FALSE),"")

and this in K4:
=IFERROR(VLOOKUP(H4,Table1,3,FALSE)-(SUMIF($B$4:B$19,H4,$C$4:C$19)+SUMIF(H$4:H4,H4,I$4:I4))*VLOOKUP(H4,Table1,2,FALSE),"")

Drag both formulas down through row 19. You can then copy/paste K4:K19 to Q4:Q19.

See attachment for clarification.

Thank you, Thank you.

Can we also have the Credit in this case ($250) goes down on each lesson? now its just stays as is.

Not without VBA (which is not my strong suit).

You can't have a formula (for current credit) and a manually entered value (beginning credit) in the same cell.

As it sits, the formulas subtract the sum of the yellow columns in the 'november' sheet from the "Credit" column in the 'students' sheet.

Hopefully somebody else will be able to help you there. Might require a re-vamp of what I was able to do through formulas.

That's OK you where great help thank you very much

You're welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Please just realised a problem I have attached a sample where
cell K16 has no data showing, it should show $(100.00)
then cell Q14 should be K16 (100.00) + Q14(150) = (250.00)

And the main problem, how can I continued the first row calculation to second row, and then to 3rd , 4rt and so on.
with same principle.
Please I really been trying to get it working, but being newbie did not do much help.


Thank you

Im so sorry about that, that part was fixed, how about the second part of my question.