How to get an Account Total to stay the same?

[softzmedia]

Hi Guys,

I know this is my first post, But I am completely confused how to get what I'm trying achieve. Still a novice at EXCEL so sorry in advance if it is easy

I have attached my spreadsheet I am working on.

What I want to achieve is:

In the Kit total(H3) - to show what the total amount of the Kit box was after that game.
Take what was in the kitty then add the G3 amount to get the total that was in the kitty after that game


I tired Sumif but couldn't get the formula working due to the kitty always changing?
and the fact the the kitty can have amounts added and subtracted?

Not sure I am making too much sense but any help is great appreciated.
Becky's Bingo Tracker.xlsx

[newdoverman]

There is something wrong with your file. Try uploading again.

[softzmedia]

Sorry, I have reattached the file;
Becky's Bingo Tracker_UPDATED.xlsx

Non sure if im making much sense, But even just a start point would be great as I have no idea how to do it

[FlameRetired]

So you want to use the value of the Kitty as of the corresponding date in A3 ?

[softzmedia]

Hi Flame,

Thank you for the reply.

Correct the kitty total as what it was the date teh entry is put in(A3 Date)

[FlameRetired]

Try this:

Please Login or Register  to view this content.

[softzmedia]

Works a treat.

Thank you that is awesome, Make it look so easy lol

[FlameRetired]

Glad it works. Thanks for the feedback!

[newdoverman]

I see that you have already received what you want.

If you are satisfied with the solution, please mark the thread as Solved found in the Thread tools just above your first post.