Need to use either COUNTIFS or SUMPRODUCT to count rows based on multiple criteria

Hello,

I have been struggling to locate a solution for my current predicament. I have spreadsheet of customer service inquiries, which includes both the date created and date last modified in two respective columns.

I am making a dashboard to breakdown date ranges of the inquiries. I have performed counts of all inquiries from today, all inquiries from this month, and all inquiries to date. Each inquiry also has a status (open or resolved). Now I am working on getting counts for how many inquiries were resolved on the same day for each of those sub-counts (i.e. how many inqueries were resolved today, how many resolved on the same day for this month, and how many total resolved on same day).

For the cell where I am trying to compute the total inquiries responded to on same day this month, I am running into some issues and am not sure how to add in the criteria for it to count when the created date column equals the last modified date, and the status is set to "resolved."

Here are the current cells for the dashboard and the corresponding formulas I have to give you a better idea:

Total inquiries today: =COUNTIF('Raw Data'!J2:J1048576,TODAY())
Total inquiries this month: =COUNTIFS('Raw Data'!J:J,">="&DATEVALUE(MONTH(TODAY())&"-1"&"-"&YEAR(TODAY())),'Raw Data'!J:J,"<"&DATEVALUE(MONTH(TODAY())+1&"-1"&"-"&YEAR(TODAY())))
Total inquiries to date: =COUNT('Raw Data'!A2:A1048576)
Total inquries responded to today: =COUNTIFS('Raw Data'!J2:J1048576,TODAY(),'Raw Data'!D2:D1048576,"Resolved")
Total inquiries responded to same day this month: ???? NEED HELP!!!
Total inquiries responded to same day to date: =COUNTIF('Raw Data'!D2:D1048576,"Resolved")


Please help - and let me know if you need me to clarify anything. Thanks.

OK, I have sanitized the data and have attached the workbook to show you what I am trying to do. Let me know if you have any other questions or points. Thanks for your time!

CS Dashboard Template Dummy.xlsx

This is quite nice. Thank you very much for the help! Just to better understand how this formula is working, do you think you could provide any further breakdown of how the formula is working exactly, or direct me to a good resource on SUMPRODUCT capabilities? I slightly tweaked what you provided but it seems to be working beautifully. I added another condition for it to sum only "Resolved" cases. I have practically no experience with this formula so this great to learn.

Thanks again.