Multiple Criteria's

[rosarionyc]

Hello guys-

I have these two formulas below that I wish to add 3 criterias to…

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

Criteria =

G$1:$G$10000= "4-more time"
G$1:$G$10000= "3-recall"
G$1:$G$10000= "6-follow up"

=IFERROR(AVERAGEIFS('3-Service Calculator'!$S:$S,'3-Service Calculator'!$G:$G,"1-serv call",'3-Service Calculator'!$X:$X, 1)/24,0)

Criteria =

G:G= "4-more time"
G:G= "3-recall"
G:G= "6-follow up"

Any help will be greatly appreciated. Thanks in advance for your assistance!