INDEX/MATCH/SUM type foruma

It would be helpful if you could upload a workbook. This should include a sample of your data as well as the results you're trying to achieve. In order to upload, click Go Advanced, then Manage Attachments. Click Browse to find your file, click Open, then click Upload. Click Close this window, and your file will be attached when you submit your reply.

As Melvosh has said a workbook would be useful.

Don't forget that if you record your data in a regularised two dimensional table suitable for use by a Pivot Table then you can usually derive all the analysis you need from the PT without the need for formulae.

In D21 cooied down and across

Formula:

Please Login or Register  to view this content.

However this isn't the best way of holding your data for any really useful analysis. I'd urge you to create a table with columns
for

Date - typical values 1/1/2019...etc.
Project ID - typically 12345, 12346 etc.
Phase - typically PB, EP etc.
Person Days, typically 50, 25 etc.

i.e. one record row for each unique set of information