Sum if criteria matches Row and column values

I have this table in one sheet.

This is my other summary sheet


In my other sheet I wanted to auto calculate if name and week number matches

like Sumif name is x and week is 1 so answer i should be getting 7 (i.e. 4+3). Please help.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!