Countif item is = 20% of total of range
I am trying to write a countif statement that will count "not sum" in a item is = 20% of the total set items.
Example Revenues: 4,186.63 21,043.25 9,574.95 1,056.00 134,111.20 30.00 35,293.72 11,555.45 The example should send back a total of 3. |
Quote:
...however as 20% of the total of the above comes to 43,370.24, this results in 1 being greater or equal to that value in your example. |
All times are GMT +1. The time now is 09:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com