Need help with formula

[itzzjason]

	A	B	C	D	E	F	G	H
9	Date	Location	Limit Type	Game	Stakes	Buy-In	Cashed Out	Net
10	2/17/22	Home game	NL	HE	0.50/1	200	380	180
11	2/18/22	Casino 1	NL	HE	1/2	300	900	600
12	2/19/22	Casino 2	Spread	HE	1/3	500	600	100
13	2/20/22	Home game	PL	O	1/2	600	100	-500
14	2/21/22	Casino 2	NL	HE	1/2	300	0	-300

The above table is a sample of what my spreadsheet looks like. I use it to track my poker sessions' results.

There's 1 cell I'm having a hard time coming up with a formula. I want it to display the percentage of profitable sessions while my results are unfiltered/filtered.

If I were to filter the results to show only my sessions at Casino 2, the cell would show 50% profitable sessions. Or all my Omaha sessions, the cell value would be 0%. Unfiltered results, the cell value would change to 60%.

 

[Candyman8019]

what formula are you using to get your results currently? you should be able to modify it and use SUBTOTAL function which can ignore filtered rows.

 

[itzzjason]

what formula are you using to get your results currently? you should be able to modify it and use SUBTOTAL function which can ignore filtered rows.

I originally wanted to use SUBTOTAL with some sort of COUNTIF function code. But I couldn't find COUNTIF under SUBTOTAL.

 

[Fluff]

How about with a helper column

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I
7									0.6
8
9	Date	Location	Limit Type	Game	Stakes	Buy-In	Cashed Out	Net	Visible
10	2/17/22	Home game	NL	HE	0.50/1	200	380	180	1
11	2/18/22	Casino 1	NL	HE	1/2	300	900	600	1
12	2/19/22	Casino 2	Spread	HE	1/3	500	600	100	1
13	2/20/22	Home game	PL	O	1/2	600	100	-500	1
14	2/21/22	Casino 2	NL	HE	1/3	300	0	-300	1
Data

Cell Formulas
Range	Formula
I7	I7	=COUNTIFS(H10:H20,">0",I10:I20,1)/COUNTIFS(I10:I20,1)
I10:I14	I10	=SUBTOTAL(3,A10)