Multiple Criteria's

Originally Posted by NBVC

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

Thank you, that worked perfectly. Currently i am looking into the 2nd formula you provided me. Seems to have given me a lesser SUM than the original formula; BRB soon.