Merging 2 Columns on 2 Separate Spreadsheets into 3 Spreadsheet

Folks,

I was hoping folks on this forum could help me with a reporting workbook.

I have a workbook that I am using to count hits on website articles. I am producing a monthly report for each month through December, 2021. There will be 6 spreadsheets of month results and 1 spreadsheet name Summary.

The columns in the 6 spreadsheets are:

Report Date
Title
Page Views
Type

What I am trying to do is to unique merge the Title Column of each of the 6 spreadsheet into one column on the Summary spreadsheet. This would result in all unique values of title for the 6 months, July to December.

There are months columns on the Summary spreadsheet. These columns would contain the Page Views for that respective unique column. Some months may not have a value. For example, the August spreadsheet has Twitter Summary, rows 73 and 74 that are not in the July 2021 spreadsheet. The title would be listed on the Summary spreadsheet but have no Page Views for July. The Page Views would be 9 and 0, respectively for August.

I have no clue how to accomplish this feat. I reviewed the other post on the forum, but have a hard time understanding the solutions.

I am using Microsoft 365, latest version. I have attached my workbook for review. I hope I did this attachment correctly!

Any help you could provide to me would be GRATELY APPRECIATED!

Thanks,
Joe

Alan,

Thanks for the prompt reply! The only issue is that the title is dynamic. We are posting articles (Titles) over the months. They are not predefined. I won't know some of the titles for the coming months, since we haven't posted them yet.

Thanks,
Joe

Another options since you have 365 is to use Dynamic Array formulas.

Also, I put your lists into Excel Tables so it's easier, more efficient.
To get the unique titles on the summary (and also to sort them in alphabetical order if you want), enter this into cell A2:

Please Login or Register  to view this content.

Then in C2, you can enter this dynamic formula that will SPILL down the page:

=SUMIFS(Table1[Page Views],Table1[Title],$A2#)

You can copy this under August and just change the Table Name. If needed, you could probably also use INDIRECT to just copy the formula over but if you're just using 6 months, it's probably easiest/best to just reference the tables directly.

See attached