asked on 4/3/2020

Excel - # of phone calls answered and abandoned in 30 seconds or less

Need a formula to show the number of calls answered (shown in column F/Answered) in 30 seconds or less (shown in column H/Ans.Delay) - show results in cell F39

Need a formula to show the number of calls abandoned (shown in column G/Abandoned) in 30 seconds or less (shoCCS-S-Clinic-April-2020-Monthly-Cal.xlsxwn in column I/Aban.Delay) - show results in cell G40

Microsoft Excel Microsoft Office

Last Comment

Jacques Geday

4/4/2020

Subodh Tiwari (Neeraj)

4/3/2020

Try this...

In F39

=COUNTIFS(F2:F35,1,J2:J35,"<="&TIMEVALUE("00:00:30"))

Open in new window

In G40

=COUNTIFS(G2:G35,1,J2:J35,"<="&TIMEVALUE("00:00:30"))

Open in new window

ASKER CERTIFIED SOLUTION

Louis LIETAER

4/3/2020

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Jacques Geday

4/4/2020

Put in F39

=COUNTIFS(F20:F35,1,H20:H35,"<=00:00:30")

Open in new window

Put in G40

=COUNTIFS(G20:G35,1,I20:I35,"<=00:00:30")

Open in new window

gowflow

Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K

Questions

Followers

Top Experts

Get a personalized solution from industry experts

Ask the experts

"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23
"Your help has saved me hundreds of hours of internet surfing."
@fblack61
"Just a dang good service!"
@golferski
"Worth every penny."
Steve Hougom
"It’s been a life saver."
Maria Halt
"Best support site I’ve seen!"
Bob Schneider
"I would be lost without them."
@fblack61
"Saved my job multiple times."
Walt Forbes
"I love this site."
Maria Duwe
"Friendly respectful help."
Andrew Kowtalo
"Such top-notch experts."
@magento
"The best money I have ever spent."
@rwheeler23
"Beyond any comprehensible value"
George Morris
"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23

Read over 600 more reviews

TRUSTED BY