tarquinious tarquinious is offline

Member

Posts: 31

Quote:

Originally Posted by Randy Mis

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need a formula to sum no of times item no is used and sum up total quantity!	Amean1	Excel Worksheet Functions	1	June 23rd 07 04:42 PM
General summary total by item	CleverCat	Excel Worksheet Functions	1	November 21st 06 12:57 AM
calculated item does not work in grand total column in Pivot	Valerie_NOLA	Excel Discussion (Misc queries)	0	February 10th 06 06:28 PM
Pivot Table Grand Total - Calc Item	cjb2486	Excel Worksheet Functions	0	June 13th 05 08:33 PM
My Pivot total just repeats item data	Savril	Excel Discussion (Misc queries)	1	January 4th 05 01:20 AM

All times are GMT +1. The time now is 09:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us