Is there a better way to count the date attempts into a summary sheet
Maybe not the most eloquent title
Basically I have a tracker that colleagues are using for attempts to call a customer, they can only attempt a maximum of 3 times
So in the source data I have 3 columns which they enter the date they attempted to contact the customer
In a summary sheet I have made I have the layout of the colleagues name on the left and along the top 2 rows (a start of week date and end of week date)
My formula right now is 3 separate countifs with a + between them and that gives the total attempts the colleague has made that week
I.e COUNTIF(date ranges (>=|<=), customer attempt 1 date) + COUNTIF(date ranges (>=|<=), customer attempt 2 date) + COUNTIF(date ranges (>=|<=), customer attempt 3 date)
Just want to know if there's a cleaner way to do this
[link] [comments]
Want to read more?
Check out the full article on the original site