| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a formula to sum no of times item no is used and sum up total quantity! | Excel Worksheet Functions | |||
| General summary total by item | Excel Worksheet Functions | |||
| calculated item does not work in grand total column in Pivot | Excel Discussion (Misc queries) | |||
| Pivot Table Grand Total - Calc Item | Excel Worksheet Functions | |||
| My Pivot total just repeats item data | Excel Discussion (Misc queries) | |||
Linear Mode
