Sumifs Smartsheet multiple criteria assistance

Options

Hello, I am needing assistance with trying to create a formula in Smartsheets that will count the duration of time for a specific Person/Year. Any help would be appreciated.

EX:

Data Sheet:

Metric Sheet:


Looking for a return on the Metric Sheet to read:


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!