Worksheet summary data for catagories to calculate amounts.

I am away from my computer for a few days. Will look into this when I can.

If I understand correctly then the following formula will populate the Profit Line column:

Formula:

Please Login or Register  to view this content.

The formula is based on both the Site and Buy-in Category.
I'll leave it to you to put the column headers into row 52.

Mate, I added a few games with name of Site. after testing. in the search for site in allresults B45 All not giving the results of the games I input all other sites seem to be working. can the All games F45 be adjusted to show games by site. Partypoker for all shows (11/21) should be (1 / 1) 1 rebuy 1 ft and 1 win
Also can we add the rake amount in buyin column O52. and if the Player name can appear In Cell 51 once is change in the site search by site. thank you mate. will upload

fff.png

Mate, will upload the workbook I would like to workon Pretty much all stats are done from above workbook.
would like to remove the Monday list and have the Pivot table with all Sites, using only the tournaments sheet for inputing all games for all sites. here is the workbook. let me know what you think and I can create new thread.

Changes have been made to the formulas based on the values in cells B45 and F45.

thank you mate, will see changes. please see the workbook in post #206
question on the All site and All Games can it be adjusted to show the games and all buyins along with all other stats or it wont work properly ?
also for ACR all shows only this

6666.png

also when choosing Pokerstars All it shows but not the name of the tournament.

Fixed formula for Entrants through Rebuys columns based on site = ACR and all games = ALL

thank you mate. nice is working really well
after testing I only see when choosing All for any site it shows games but not the names of the tournament.

The rest of the formulas are now modified.

happy morning mate, thank you, will donwload see changes.

Mate, why for All All its not working or for ACR All won't show the name of the tournaments

See if this works the way you want.

Thank you mate, its working but not the rebuys, ft and wins for All and all i think.
mate can we continued with the cash stats in the next sheet tab.
for all and all can we get the buyins and rebys ft, and wins. also to display ALL games where it shows #N/A

As stated by the administrator in the previous thread. Once the original question, in this case about filling the allResults sheet, is answered the thread needs to be closed.
The attached file addresses the "All All" issues on the allResults sheet.

Hopefully this addresses all the issues raised in posts 219:222.
Note that I don't understand how "total of buyins $70.60" could be correct.

Thank you mate, will check the changes. also not sure if you saw msg. in post #216 from artur were any changes done? let me check amt. maybe i was wrong mate.

mate, for pokerstars micro game. buying in allresults is not correct buying is $5 but instead shows $3 not sure also if all others are adding the Rake Fee amt.
also thank you for the FT Wins you added

New formula in column AG on the Tournaments sheet is: =SUM([@[Buy-in]],[@Rake])*SUM([@Rebuy],1)

Thank you, mate will look into it. downloading
cool nice working now. Mate, will create new thread and reupload workbook. I am working on the previous workbook. I will paste new formula to workbook. once done ill upload. ty mate

In the new thread I suggest that you be very specific with cell/cells you want populated by the request.
Give contributors expected results as you did in in post #222.
Don't refer to just one contributor, give everyone a chance to provide input.
I hope that you have a blessed day.