Trying to calculate the instances of certain occurrences happening.
Count EVERY 1 to 1
Count first instance of Group 1, 2 and 3
Do not count Absent:
I want to calculate it at the bottom of the range B5:B16 (so in cell B17).
can get certain aspects of the formula but not fully working...