Multiple Criteria's

Originally Posted by NBVC

You mean you want to add if G1:G10000 is either of those conditions?

If so:

=SUMPRODUCT((('3-Service Calculator'!$G$1:$G$10000="1-serv call")+(G$1:$G$10000= "4-more time")+(G$1:$G$10000= "3-recall")+(G$1:$G$10000= "6-follow up")),--('3-Service Calculator'!$X$1:$X$10000=1),'3-Service Calculator'!$S$1:$S$10000)/24

and

=IFERROR((SUMPRODUCT((('3-Service Calculator'!$G$1:$G$10000="1-serv call")+(G$1:$G$10000= "4-more time")+(G$1:$G$10000= "3-recall")+(G$1:$G$10000= "6-follow up")),--('3-Service Calculator'!$X$1:$X$10000=1),'3-Service Calculator'!$S$1:$S$10000)/SUMPRODUCT((('3-Service Calculator'!$G$1:$G$10000="1-serv call")+(G$1:$G$10000= "4-more time")+(G$1:$G$10000= "3-recall")+(G$1:$G$10000= "6-follow up")),--('3-Service Calculator'!$X$1:$X$10000=1)))/24,0)

Note: Countifs, Sumifs, Averageifs don't take OR condtions....

Hello and thank you. The 1st formula seem to work but i am not yet sure of it because there is a 2nd formula in which i need to alter as well. I tried to follow the format as described in the 1st formula but i got an error messege, this is why i am posting the 2nd formula for your review. Thanks!

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

Additional Criteria =

'3-Service Calculator'!$G$1:$G$10000="8-high part"