In Excel 2016 (provided you have always 2 jobs per show) this in D16 and copied to the right shall do the task:
Formula: copy to clipboard
=SUMPRODUCT(--(COUNTIFS($C7:$C14,$C7:$C14,D7:D14,">0")>0))/2