Sumifs - help to do sum with two rows range to match criteria

[prasaddn]

Hi All,
I have data of planned and actuals for every team member across different projects in specific format given below. I have also attached the sample workbook.

Planned

Actuals

Planned

Actuals

Planned

Actuals

Planned

Actuals

Planned

Actuals

Planned

Actuals

Team Members

Project1

Project1

Project2

Project2

Project3

Project3

Project4

Project4

Project5

Project5

Project6

Project6

Name1

4​

3​

2​

3​

2​

2​

1​

2​

1​

2​

0​

0​

Name2

5​

4​

3​

4​

3​

3​

2​

3​

2​

3​

1​

1​

Name3

3​

2​

1​

2​

1​

1​

0​

1​

0​

1​

0​

0​

Name4

5​

3​

3​

3​

3​

2​

2​

2​

2​

2​

1​

0​

Name5

Name6

Name7

Name8

Name9

Name10

Name11

Name12

Name13

Need formula to sum of all numbers from table by matching criteria1 planned or actuals and then criteria2 project#.
Example of output:
17 should be result of formula based on first criteria "Planned" matching in data row 1, and 2nd Criteria "Project1" matching in data row 2, and then summing all the rows from the data.

	Planned	Actuals
Project1	17​	12​
Project2	9​	12​
Project3	9​	8​
Project4
Project5
Project6

I could not solve with sumifs, but looks like i may need to use different formulas like mmult or sumproduct.
the sample workbook as data and expected output for which I need formula.

 

[ETAF]

how about
=SUMPRODUCT(($C$3:$N$15)*($C$1:$N$1=S$1)*($C$2:$N$2=$R2))

 

[prasaddn]

Thank you ETAF!
This works.

I think i had lost my mind. :D

 

[ETAF]

you are welcome