Good explanation.
What Excel function would you choose?
Good explanation.
What Excel function would you choose?
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
wow mate, you talking way to much excel for me. Honest I don't know mate sorry
there are to many funcions, I don't know anything about.
Vlookup maybe?
=sumproduct I think it would be
Last edited by west123; 04-06-2023 at 10:42 PM.
Very good.=sumproduct I think it would be
Ends up that the formula for E3 is somewhat complicated because cells in the Date Time column on the Tournament sheet are text:Formula:Please Login or Register to view this content.
I went ahead and filled in E3:E6.
On the other hand cell E7 already contained the SUM function which will work, and which I assume you or someone else put there.
At the moment it is summing E10:E10 which is a blank cell so obviously not going to work. I have faith that you know which table and column on the Tournament sheet has the needed amounts and can put the correct argument inside the parentheses.
Happy morning Mate
thank you extremly complicated, I would say
okay cool yes it would off been me since its only you or me making the updates. I don't know if I can figure that one out. mate will donwload and see the changes. thank you
Mate, sorry I can't figure it out.
i try
=SUM(tbl_CashGames[ah3])
=SUM(tbl_CashGames [profit]) its very hard for me when I don't know anything about the arguments or the meanings.
WOW miracle God did this nice I got super lucky, I try so many things even look at a bunch of old workbooks to find how to fixed it.
Honest don't know anything about this excel formulas or meanings.
this is how I figure it out. I look at the Month Cash Profit above in E6 and just copy this from the formula =SUMPRODUCT((tbl_CashGames8[Profit])
add it and gave me -$20.00 otherwise I wounldn't figure it out.
please check its correct. Also can you format it to give me amount in red (-20) when negative
Last edited by west123; 04-07-2023 at 02:52 PM.
Mate, can we do the Total Deposits in E9
God has faith in you, and I believe for more than just figuring out Excel.
As to cell E9:
1. Convert the range A2:D57 on the Tournaments sheet into an Excel table
2. In cell E9, similar to your formula: =SUM(tbl_AllTransacations[Amount])
Question: Why are there three named ranges for transaction? It may be that if there was only the one that refers to Info!$F$3:$F$9, tbl_AllTransacations could be shortened to only contain rows with data and the drop down would still work.
Let us know if you have any questions.
Mate, your making me laught now LOL
Thank you mate, Not sure why, will check the changes. thank you mate.
Mate, can we start the other stats, total profit
I have changed the reference for the drop downs in the Transactions column to: Info!$F$3:$F$7.
I also shortened tbl_AllTransacations to only the rows having data. When you select cell D5 and press the Tab key cell B6 in the new table row should be a drop down cell.
I have put a formula in cell I3 from which I feel you can figure out the formula for cell I4 (like what you described back in post #204).
I also put a formula in cells I5 and I9 and will leave I8 in your capable hands.
We need you to explain what you mean by ROI and Buyin ROI so that we can attempt to write a formula for those.
Have a good night.
Thank you a bunch mate Thank you
cool, I will see changes and try to figure out what you mention above which, I think would be really hard.
but I may be able to do the ROI and Buying ROI Good Night mate
I aslo will Upload workbook since I made changes to the Tournament columns but will not affect much but do need a few formulas
this the way to go mate, I fianaly will workout with this new layout of the tournaments, but will save me a tons of time having to do the
input. will upload when Im done.
Mate, for RIO Is going to be =i3/ tournament sheet column D 3: all deposits in table.
I don't know how to write that
Is this still your original question? If not, please start a new thread for the new question.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi,
Yes its my original question. let me know if thats fine. cheers
If it is still the 1st question, please continue
Thank you,
Mate, Please see updates, in the tournament section.
Also not sure why some of the catagories in the allResults not showing the amounts, like Sit n GO JPT
The first question concerned filling in column F in a different workbook.
Private message me when you have complied with the administrator's request to open a new thread.
Good morning mate
I update the layout in tournament thats why.
administrator said its fine we can continued with this thread.
I said it was fine if this was still concerning your original question.
sorry for late response. thank you mate,. I know just want to complied in case if it wasen't also the thread was pretty long. ty again cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks