Chalklands
New Member
- Joined
- May 17, 2018
- Messages
- 13
Hello,
I have a formula that calculates Deals 'Won'' as a % of Total Deals ('Won'+'Lost').
<tbody>
</tbody>
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
I have a formula that calculates Deals 'Won'' as a % of Total Deals ('Won'+'Lost').
=IFERROR((COUNTIF(Tbl_Deals_1[Status],"WON")/SUM(COUNTIF(Tbl_Deals_1[Status],"WON"),COUNTIF(Tbl_Deals_1[Status],"LOST"))),"") |
<tbody>
</tbody>
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