Hello Guys-
Here goes another one of those string formulas I love.
Id like to add the following criteria’s please’![]()
=IFERROR(AVERAGEIFS('3-Service Calculator'!$L:$L,'3-Service Calculator'!$G:$G,"1-serv call",'3-Service Calculator'!$X:$X, 3)/24,0)
'3-Service Calculator'!$L:$L,'3-Service Calculator'!$G:$G,"3-recall"
'3-Service Calculator'!$L:$L,'3-Service Calculator'!$G:$G,"4-more time"
'3-Service Calculator'!$L:$L,'3-Service Calculator'!$G:$G,"6-follow up"
Thanks! =)
Bookmarks