In Excel 2016 (provided you have always 2 jobs per show) this in D16 and copied to the right shall do the task:
Formula:
=SUMPRODUCT(--(COUNTIFS($C7:$C14,$C7:$C14,D7:D14,">0")>0))/2
In Excel 2016 (provided you have always 2 jobs per show) this in D16 and copied to the right shall do the task:
Formula:
=SUMPRODUCT(--(COUNTIFS($C7:$C14,$C7:$C14,D7:D14,">0")>0))/2
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks