Hi All,
I have a data table where we have Roles 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 with new entries. I have tried Sumproduct, countif and other array functions but am unable to get the right results.
Any help will be appreciated.
I have a data table where we have Roles 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 with new entries. I have tried Sumproduct, countif and other array functions but am unable to get the right results.
Any help will be appreciated.