Hoping to get some help, my excel skills are not what they used to be but think i came to the right place!
I have attached a sample data sheet which will help explain what I am trying to do. I'd like to count the number of times a name appears in the data set between two specific dates.
For the first name (bob) - On the "Summary" Tab, I want to count the number of times his name appears in the "Data Tab" in column I between the dates 8/3/2019 and 8/30/2019 - the dates are in column D.
I'm assuming I'd use the countifs function, but had a few issues. Please let me know if I can provide additional information!