Worksheet 'Dashboard' has a weekly breakdown for production numbers. I have tried multiple ways and continue to get formula errors. I need to count the number of entries in multiple other worksheets as follows:
Worksheet: DG_Procedures has table DG_Table with column Date Submitted to QC. I need to count the amount of entries within this column based on date range on worksheet Reference cells E4 and F4. E4 is the start date and F4 is the end date. it needs to be inclusive of those dates.
I have 4 more worksheets that will add the same exact column information and date references. Those worksheets are CC_Procedures with table CC_Table, IL_Procedures with table IL_Table, JB_Procedures with table JB_Table, and BR_Procedures with table BR_Table. I need all of this tables to combine into the dashboard to give a final total of production numbers across the team based on the date ranges in worksheet References.
I have tried using COUNTIFS, DCOUNT, and SUMPRODUCT, none of which seem to work. I tried other tutorials and none of them seem to include tables so I'm not sure if that is the problem.
If anyone has an idea it would be much appreciated.
Worksheet: DG_Procedures has table DG_Table with column Date Submitted to QC. I need to count the amount of entries within this column based on date range on worksheet Reference cells E4 and F4. E4 is the start date and F4 is the end date. it needs to be inclusive of those dates.
I have 4 more worksheets that will add the same exact column information and date references. Those worksheets are CC_Procedures with table CC_Table, IL_Procedures with table IL_Table, JB_Procedures with table JB_Table, and BR_Procedures with table BR_Table. I need all of this tables to combine into the dashboard to give a final total of production numbers across the team based on the date ranges in worksheet References.
I have tried using COUNTIFS, DCOUNT, and SUMPRODUCT, none of which seem to work. I tried other tutorials and none of them seem to include tables so I'm not sure if that is the problem.
If anyone has an idea it would be much appreciated.
