Hi JJ, pls. share an example highlighting the results you need.
regards, Basole. Em segunda-feira, 30 de dezembro de 2013 20h33min59s UTC-2, JJ escreveu: > > > I have a spreadsheet, to keep my Craps game activity straight. > I've used it from the very beginning of my play. The only columns I have > so far are these: > > Date, Buy-in amount, Cash-out amount, WINS, LOSSES, table minimum, fuel > expense, lunch expense > > So, now I'm needing to add two new columns together: > > > *WHAT I HAVE:*Cell A2 works. > It consists of this formula: > =B4-C4 (B4 is Buy in amount), and (C4 is Cash out amount) > > =SUM(D:D) (in cell B4) and =SUM(E:E) (in Cell C4) > > That stuff works. > > > *WHAT I NEED:*Almost the same thing as what I have, but I don't know. > I need to add the two new columns: Fuel expense and Lunch expense together. > Then, I need to subtract that sum from from cell A2 > > =b4-c4 (B4 is my buy-in column, and c4 is my cash out column. This > subtraction operation tells me what I have at the end of the day). > The result is placed in cell: A4 > > So, cell A4 which is 2 rows under A2, is to reflect the real amount, after > expenses incurred today. > I know this is stuff that many of you kind people can do in your sleep. I > wish I was one of them :) > > Please help me fill out what's needed. > Thank you very much. > > > > What I can't figure out is > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
