Count of date values which are in different columns but are of same week in pivot table

Usmankhan

New Member
Joined
Mar 9, 2022
Messages
1
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
Platform
  1. Windows
  2. 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
 

Attachments

  • 1st Image.PNG
    1st Image.PNG
    66.9 KB · Views: 32
  • 2nd Image.PNG
    2nd Image.PNG
    58.1 KB · Views: 32

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Forum statistics

Threads
1,223,886
Messages
6,175,198
Members
452,617
Latest member
Narendra Babu D

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top