Posted to microsoft.public.excel.misc

Rene

external usenet poster

Posts: 74

greater than less than

How do I insert (F2:F1050) into the formula? Percentage of numbers between
50 and 100

SUMPRODUCT(--(M2:M10="b"),--(F2:F10<100))/COUNTIF(M2:M10,"b")

Thanks in advance.

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
Greater than # but less than #	ph3nom3nalwoman	Excel Worksheet Functions	3	May 26th 08 08:47 PM
If sum greater than 12 use 12	Smudge	Excel Discussion (Misc queries)	7	April 26th 07 12:22 PM
if value is greater than # * by 20% if less * by 40	sypher	New Users to Excel	1	November 9th 06 06:10 PM
Greater Than but Less than	KaraGilsdorf	Excel Worksheet Functions	5	October 18th 06 08:42 PM
IF greater than Zero	dtruelove	Excel Worksheet Functions	6	September 21st 06 03:06 PM

All times are GMT +1. The time now is 02:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us