I'm receiving a 0 as the result of a sum formula where the result should be 4
This is a golf spread sheet I created to track my stats. Each column starting with E is a separate round of golf. In E143, I'm trying to calculate scrambling success for the round (see full formula below), where scrambling success is defined as the number of times with par on the hole and 1 or fewer putts (meaning you missed the green, but still got a par). Yes, I'm going to add birdie scrambles to this at a later date, but right now, I need to solve for par scrambling success. The hole numbers are in column A.
To calculate this, I need two comparisons:
- My score must be = par, so I'm comparing my score in E5:E23 (note the break in E14) from the par for the hole in B5:B23 (note a break in B14 as well).
- Putts must be less than 2, so I'm evaluating E70:E87 (note there is no break in this array) < 2
If both are true, then 1, else 0, and then I want to sum those numbers for the total times I successfully scrambled that round. I'm using the formula below, but it's coming up with a 0 for the total when I should be getting 4 (hole numbers 4, 5, 6, and 12). Can anyone help me understand why?
=SUM(IF(AND(VSTACK($B$5:$B$13,$B$15:$B$23)=VSTACK(E$5:E$13,E$15:E$23),(E$70:E$87)<2),1,0))
[link] [comments]
Want to read more?
Check out the full article on the original site