Results 1 to 3 of 3

Thread: Formula for break up score

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 08-14-2013, 03:29 PM #2
    LalitPandey87
    LalitPandey87 is offline
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    14
    Aplly below formula with CSE (Ctrl + Shift + Enter) as it is an array formula

    =SUM(N(($E$4:$E$21=$G1) * ($D$4:$D$21="Yes")))/SUM(N(($E$4:$E$21=$G1)*($D$4:$D$21 = {"Yes","No"})))

    and drag this formula till value "C" in column G

    If it is not working then could you please tell us how you are calculating indivisual score.
    Last edited by LalitPandey87; 08-14-2013 at 03:32 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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