ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Countif item is = 20% of total of range (https://www.excelbanter.com/excel-worksheet-functions/270410-countif-item-%3D-20%25-total-range.html)

Randy Mis

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.

tarquinious

Quote:

Originally Posted by Randy Mis (Post 964884)
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.

The formula for this is =COUNTIF(B3:B10,"="&SUM(B3:B10)*20%)
...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