I am trying to make a formula that is essentially a SUMIF, but based on the criteria the formula adds to cells. Probably an example is best.
For each "5i" in column B, add the value in Column A to the value in column C. Then, divide by the count of "5i" in column B.
Effectively, the formula would automatically calculated ((195+-2)+(200+8)+(205+4))/3 = 203.3
[ A ] [ B ] [ C ]
Yardage Iron -Lft / +Rgt
195 5i -2.0
135 9i 11.0
200 5i 8.0
120 PW -7.0
205 5i 4.0
175 7i -16.0
Bookmarks