1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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

submitted by /u/Senpai1245
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#rows.com
#generative AI for data analysis
#natural language processing for spreadsheets
#AI formula generation techniques
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#COUNTIF
#count attempts
#formula
#summary sheet
#tracker
#customer contact
#total attempts
#date ranges
#maximum attempts