Please see attached Office 365 Business Excel spreadsheet for reference.
On the first tab, Tracker, I have data validation in Cells B2:D500 with a dropdown list based on values in the Sales Activity Variables tab. I have also established a data tab, where I want to accomplish the following:
- Display a total count (sum) of the number of times each sales activity variable was completed in the last five days relative to the current day
- Sum/count of the total time spent on each sales activity variable over the past five days relative to the current date
I've tried several variations of the COUNTIFS, SUMPRODUCT, etc. formulas with no luck. I have no idea how to accomplish this. Trying to get the date range to display properly ends in an error every time. Thanks for your help!
Bookmarks