Forum Discussion
Stuck on offset counting if conditions met
Any help greatly appreciated! https://1drv.ms/x/s!AnFi6uGE1reki3wSipwTCD-hIefq?e=plHvk0 in the game of pool a player can play a "safety" which can usually will give a difficult shot to the oppon...
i added a formula to show the count for rack 2 if there was one safety. but there can be multiple safetys in a rack. i want to have in the whole match though.
=COUNTIFS(data[safety],"",data[rack],2,data[inning],XLOOKUP("yes",data[safety],data[inning])+0.5)
=COUNTIFS(data[safety],"",data[rack],2,data[inning],XLOOKUP("yes",data[safety],data[inning])+0.5)
ya no worries @dexter. im going to use a conditional column to add up when conditions met. i dont think its possible to do without. i was thinking offset and within use height to be a formula to count . but not working