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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!