Calculating row by row after applying a filter and more

[lix8]

Hello,
I rarely ask for help online, only when I'm completely lost and don't know how to move further... Like now

I've create a sheet to record sport betting results, to further look where I'm doing better or worse, check statistics, to being able to analyze and improve by myself.
It's a little confusing for me to try to explain exactly what I'm trying to do, because I don't know if Excel is capable of it and I don't have much Excel knowledge, and of course, it's not as clear as the day what exactly I want... You know, that creating process... But I'll try to break down.

- This is an example of what I'm using. I've made a column "Lucro Geral" which means "Total Profit", to being able to visualize a bet by bet graphic progression. It works perfectly, but do not works when I apply a filter.
Note that the values in "Lucro Geral" remains the same after filtering. My goal is to recalculate it automatically after I apply any filter, and therefore, the graphic would also show a correct recalculated results.
Example of the pre filtered, post filtered table/graphic and manually edited results:
Attachment 595088

- Also want to create more tables, showing the competitions/bets made/profit. Here is an example (did it manually):
Attachment 595087
Here I used Subtotal(9 function to calculate the profit and Subtotal(2 to calculate the number of bets in each competition and bet type. But of course my goal is to make it automatically, because the way I did was literally calculating one by one and writing down the results... This is just the beginning of what I want, still need to put Green/Red/Gray outcomes in these tables, also want to separate odds range to see if I'm being positive in these odds. I mean, filter like 1.95 to 2.05 odds to see the percentage of Green/Red/Gray outcomes I'm having in this odd range, to being able to see if they are bad odds or not. And of course, would like to filter these odd ranges while I'm also filtering by competition and bet type. But maybe I can get there by myself after I learn how to start doing this.

Thank you guys, sorry if I'm not being clear enough.

[Logit]

.
Not certain this is the answer you are seeking as I've not attempted what you are needing.

First link is for visible rows : https://docs.microsoft.com/en-us/off...lotvisibleonly

Second link is for hidden rows : https://www.thespreadsheetguru.com/t...in-your-charts
But I presume if you replace FALSE with TRUE it would calculate on visible rows.

[lix8]

The first VB code didn't work and the second one worked, which is really helpful to show/not show the hidden data on graphic. But my goal is to still only show the visible data on the graphics...

I tried the first VB and using my normal formula and also tried using this formula =IF(I20="";"";LOOKUP(2;1/(K2:K20<>"");K2:K20)+I20). But still it does not calculate only the visible cells. Also tried to put SUBTOTAL(9 in there just because I ran out of ideas

[lix8]

Any help? sos I'm lost

[lix8]

I really need help with this one