[Please Help Me] Solving =SUMIFS or INDEX or MATCH Formula for Data Across Tabs [Reposted]

[ChrisNeedsHelp]

Hi Everyone! Please help me with this.

I attached two images for an example of the formula I need help with. I need the SUM of Hours and Cost to populate by Employee, by Month. The real data tab carries Information thru 2020, so I need the formula consistent to where I can drag over across many columns, not just sum hours and cost columns. I also cannot change the data tab format (Everything that looks to be "Merged and Centered" is and Data Tab is already formulated / structured to how manager wants it).

If you have any suggestions or solutions to how I can get this data to pull thru it would be greatly appreciated !

[JohnTopley]

Duplicate post: I requested you added file your original post.

[JohnTopley]

In D4

=SUMPRODUCT(('Data Tab'!$E$3:$AB$3=D$13)*('Data Tab'!$A$4:$A$8=$A14)*('Data Tab'!$B$4:$B$8=$C14)*('Data Tab'!$E$1:$AB$1=D$12)*('Data Tab'!$E$4:$AB$8))

in D14

=SUMPRODUCT(('Data Tab'!$E$3:$AB$3=D$13)*('Data Tab'!$A$4:$A$8=$A14)*('Data Tab'!$B$4:$B$8=$C14)*('Data Tab'!$E$1:$AB$1=D$12)*('Data Tab'!$E$4:$AB$8))

I have ummerged cells.