Need help with formula again

[carla7216]

Good morning to you all!

I need your help please.

Here's my argument:

I have a telephone log spreadsheet that consist of multiple telephone numbers, time calls were made, duration of calls and amount charged

I need a formula to count the number of times a specific telephone number was called outside of the working hour of 3:30 PM.

Here is the formula that I tried but didn't work. I'm not getting the concept of creating an argument for a formula. (I guess I need more lessons..)

=COUNTIF(B6:B1560,">3:30 PM",D6:D1560,="203-376-3473")

Please help me if you can. I'd greatly appreciate it!!

 

[Andrew Poulsom]

Try:

=COUNTIFS(B6:B1560,">"&"3:30 PM"+0,D6:D1560,"203-376-3473")

 

[carla7216]

THAT WORKS! GREAT!

Thank you so much Andrew! I really appreciate you taking the time to help me with this formula.

Have a bless day!