Counting only visible entries in a filtered table

[Chalklands]

Hello,
I have a formula that calculates Deals 'Won'' as a % of Total Deals ('Won'+'Lost').

[TABLE="width: 100"]
<tbody>[TR]
[TD]=IFERROR((COUNTIF(Tbl_Deals_1[Status],"WON")/SUM(COUNTIF(Tbl_Deals_1[Status],"WON"),COUNTIF(Tbl_Deals_1[Status],"LOST"))),"")[/TD]
[/TR]
</tbody>[/TABLE]

It works fine, but I want it to only calculate for visible rows in a filtered table (ignoring hidden rows). Can anybody help me with this please?

Thanks

Pete

 

[Marcelo Branco]

You are welcome. Glad to help.

M.