Hello all -
I'm using this sumproduct expression to calculate a "net" score in golf. While it works great - I wish to understand "how". I get the first part that evaluates the player handicap (B9) and hole handicap (W7) to true/false, that "+" is an OR operator - what is the purpose of {0,18,36}?
SUMPRODUCT(--($B9 >= W$7 + {0,18,36}))
the plus + in this case is not an OR it adds w7 to {0,18,36}
so if w7= 8 you compare b9 to 8+{0,18,36} or {8,26,44}
so if b9 27 it would resolve to true,true,false with the --
this becomes 1,1,0 so the total is 2
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks for the clarification...the one challenge that remains is if a really good golfer is in the group and plays to a +2 he's "giving strokes" to the course on the 17th and 18th handicap holes - what change would be needed to account for this scenario? For example, the 17th hole is a par 3, he makes 3 "gross" - the net should be 4.
no idea!!!!!!!!!!!!!!!!!! thats a new question
Last edited by martindwilson; 10-02-2013 at 08:24 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks