Try:

=SUMPRODUCT((('3-Service Calculator'!$G$1:$G$10000="7-part call")+('3-Service Calculator'!$G$1:$G$10000="8-high part")),--('3-Service Calculator'!$X$1:$X$10000=1),'3-Service Calculator'!$S$1:$S$10000)/24