Usmankhan
New Member
- Joined
- Mar 9, 2022
- Messages
- 1
- Office Version
- 365
- 2019
- 2016
- 2013
- Platform
- Windows
- Web
Hi All,
I have a data table where we have Roles (varies) that people have been contacted for. Columns B:G contains the dates of the activity performed (e.g. when were they sourced, when they shared their interest so on and so forth). I need a dynamic weekly report which gives us count of all activities based on the week in 'Sourced week' column but count of all dates that match that week (in 'Pivot' sheet) and update dynamically with new entries. I have tried Sumproduct, countif and other array functions but am unable to get the right results.
Problem is when I use to get count of last four columns where week is same as of 'Sourced week of', dates which are not in the same row of selected week number, do not get included.
I need a Pivot table for the Summary (2nd pic) on the base of weekly stats as need to use these values to create charts.
Any help will be appreciated
I have a data table where we have Roles (varies) that people have been contacted for. Columns B:G contains the dates of the activity performed (e.g. when were they sourced, when they shared their interest so on and so forth). I need a dynamic weekly report which gives us count of all activities based on the week in 'Sourced week' column but count of all dates that match that week (in 'Pivot' sheet) and update dynamically with new entries. I have tried Sumproduct, countif and other array functions but am unable to get the right results.
Problem is when I use to get count of last four columns where week is same as of 'Sourced week of', dates which are not in the same row of selected week number, do not get included.
I need a Pivot table for the Summary (2nd pic) on the base of weekly stats as need to use these values to create charts.
Any help will be appreciated