+ Reply to Thread
Results 1 to 5 of 5

Yes No formula returning % help.

Hybrid View

  1. 01-08-2007, 07:04 PM #1
    pinmaster
    Guest
    Hi,

    Maybe...

    =100/(SUM(IF(C1:C10="apple",1))/SUM(IF((C1:C10="apple")*(E1:E10="y"),1)))

    enter as an array using....CTRL+SHIFT+ENTER


    Hope this helps!
    Jean-Guy
    Reply With QuoteRegister To Reply
  2. 01-09-2007, 06:08 PM #2
    caliskier
    caliskier is offline
    Forum Contributor
    Join Date
    08-03-2005
    Posts
    272
    thanks guys, very helpful!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1