NeedExcelHelp2021
New Member
- Joined
- Apr 17, 2021
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
I have a formula that works perfectly fine, though I would now like it to calculate only the visible cells when I apply a filter. The formula for identifying The Frequency of 3 or more positive values (ignoring blank cells)....
=SUM(IF(FREQUENCY(IF(LD6:LD116>0,ROW(LD6:LD116)),IF(LD6:LD116<0,ROW(LD6:LD116)))>=3,1))
Hope someone can help - Many thanks.
=SUM(IF(FREQUENCY(IF(LD6:LD116>0,ROW(LD6:LD116)),IF(LD6:LD116<0,ROW(LD6:LD116)))>=3,1))
Hope someone can help - Many thanks.