Sum multiple columns using multiple criteria

[eg8]

Hi All-

I'm looking to create a formula that I'm not sure is possible. In my spreadsheet template I have company departments in Column C4:C500 and projects in rows F3:AZ3. The actual proj ID in F3:AZ3 will vary by spreadsheet, but I have a separate Master sheet that has all projects and all departments listed in a pivot table-like format. Since there are far more proj IDs than departments, in this master list the depts are all in the same row and proj IDs in the same column. Due to the input, I cannot change the template setup.

I will be pulling many spreadsheets together and want to calculate the total where the company dept and proj matchup.

The SUMIFS statement I am attempting is =SUMIFS(C5:AZ500,"Project",cell w/ project,"Dept",cell with dept) - but the issue is you cannot do a sumif using multiple columns. Does anyone know a way around this?

Thanks in advance!

 

[eg8]

[SOLVED]

=SUMPRODUCT((Criteria1=PROJ)*(Criteria2=DEPT),(SUM RANGE))