Sumifs Smartsheet multiple criteria assistance


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.


Data Sheet:

Metric Sheet:

Looking for a return on the Metric Sheet to read:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!