Become a dv.com member, Click here to register!
    • Lucid Dreaming - Dream Views




    Results 1 to 25 of 550
    Like Tree563Likes

    Thread: Spellbee's Spooky Competition 2016

    Hybrid View

    1. 11-14-2016 04:20 PM #1
      Saizaphod
      Finland Saizaphod is offline
      Stay lucid Achievements:
      Made lots of Friends on DV Populated Wall Created Dream Journal Tagger Second Class Veteran First Class Made Friends on DV 5000 Hall Points Referrer Silver       Saizaphod's Avatar
      Join Date
      Feb 2013
      LD Count
      527+
      Gender
      Posts
      1,209
      Likes
      1521
      DJ Entries
      26
      Quote Originally Posted by spellbee2 View Post
      =SUM(B3:B14)
      =AVERAGEIF(B3:B14,"<>0")*12
      =SUM(B3:B14)+COUNTIF(B3:B14,"")*(AVERAGEIF(B3:B14, "<>0")*0.5)
      =SUM(B3:B14)+(COUNTIF(B3:B4,"")*(AVERAGEIF(B3:B4," <>0")*0.5))+(COUNTIF(B5:B9,"")*(AVERAGEIF(B5:B9, "< >0")*0.5))+(COUNTIF(B10:B14,"")*(AVERAGEIF(B10:B 14 ,"<>0")*0.5))
      =SUM(B3:B14)+(COUNTIF(B3:B4,"")*(SUM(B$3:B$4,B$18: B$19,B$32:B$33)/COUNT(B$3:B$4,B$18:B$19,B$32:B$33))*0.5)+(COUNTIF( B5:B9,"")*(SUM(B$5:B$9,B$20:B$23,B$34:B$38)/COUNT(B$5:B$9,B$20:B$23,B$34:B$38))*0.5)+(COUNTIF( B10:B14,"")*(SUM(B$10:B$14,B$24:B$28,B$39:B$43)/COUNT(B$10:B$14,B$24:B$28,B$39:B$43))*0.5)
      Last edited by Saizaphod; 11-14-2016 at 04:23 PM.
      Reply With Quote Reply With Quote  
    « Previous Thread | Next Thread »

    Similar Threads

    1. Spellbee's Spooky Competition 2016 Signups
      By spellbee2 in forum Lucid Challenges
      Replies: 47
      Last Post: 10-29-2016, 03:57 PM
    2. Spellbee2's Summer Lucid Competition 2016
      By spellbee2 in forum Lucid Challenges
      Replies: 406
      Last Post: 10-04-2016, 02:59 AM
    3. Spellbee2's Summer Lucid Competition 2016 Signups
      By spellbee2 in forum Lucid Challenges
      Replies: 40
      Last Post: 08-06-2016, 08:13 AM
    4. Spellbee2's Spring Extravaganza Competition 2016
      By spellbee2 in forum Lucid Challenges
      Replies: 346
      Last Post: 07-09-2016, 03:07 AM
    5. Spellbee2's Spring Extravaganza Competition 2016 Signups
      By spellbee2 in forum Lucid Challenges
      Replies: 45
      Last Post: 04-09-2016, 02:51 PM

    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