Help me build my bankroll spreadsheet?

[oleandrw]

Hello.

Im building a bankroll spreadsheet for myself and im almost done. The last thing i wanna get is to multiply my profit from different site, so i can see how much i got on different sites. Problem is when im going down to next match, it dont count. Obv becouse its on O08, but i dont know how to get it fully automatic.

Here is a link of the spreadsheet: Test.xlsx

 

[CA_Punit]

Edit the formula in D2 to
=SUM(IF(Table_1[Booking]=C2,Table_1[Profit]))

 

[oleandrw]

Edit the formula in D2 to
=SUM(IF(Table_1[Booking]=C2,Table_1[Profit]))

I got error :/ Feel free to try with the link. I need to add the profitt on L section aswell

 

[Fluff]

How about
=SUMIF(Table_1[Booking],C2,Table_1[Profit])

 

[oleandrw]

How about
=SUMIF(Table_1[Booking],C2,Table_1[Profit])

Thanks! But still error I think we are near something here

 

[Fluff]

Are you doing this in Excel, or Google sheets?

 

[oleandrw]

Thanks! But still error I think we are near something here

 

[oleandrw]

Are you doing this in Excel, or Google sheets?

Been tested both.

 

[Fluff]

If you are using a non English version of Excel, then you will need to convert the formula into your language.

 

[CA_Punit]

See the link it is working in our sheet

Test.xlsx

Microsoft Excel Workbook

1drv.ms