Aladin Akyurek

Posts: n/a

LostNFound wrote:
Is this counting the "yes" only with "1" in column A! Is it looking for both
criterias?
I had eight ones in column A and one yes were there was a one and it
returned 12.5% it should have returned 88%

What did I do wrong??

"Bob Phillips" wrote:

=SUMPRODUCT(--(A1:A100=1),--(D1:D100="yes"))/COUNTIF(A1:A100,1)

will give the percentage

Replace the "yes" bit with just "".

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Lookup Lookup Lookup	MR	Excel Worksheet Functions	2	March 10th 05 01:59 AM
Lookup Function Problem	seve	Excel Discussion (Misc queries)	9	February 28th 05 02:46 AM
Lookup function w/Text and Year	Josh O.	Excel Worksheet Functions	1	February 12th 05 11:27 PM
Excel Lookup Functions	Paul Adams	Excel Worksheet Functions	1	November 10th 04 02:40 PM
double lookup, nest, or macro?	Josef.angel	Excel Worksheet Functions	1	October 29th 04 09:50 AM

All times are GMT +1. The time now is 06:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us