Forum Discussion
COUNTIFS FORMULA HELP - How many calls were made from x to x per hour
I need to know how many calls were made from "Caller Number" (1053) to "Callee Number" (6400) each hour (00:00-00:59) I use the formula =COUNTIFS($A$2:$A$9999, "1057", $B$2:$B$9999, "6400" to give m...
Create a pivot table with Start time as first row field and caller number and callee number as other row fields. Then group the time column by hour. Now you can filter the table on either callee or caller number as needed.
