Summing totals with 2 variables

I am trying to sum the amount of time it takes a specific individual to complete a certain task. I am trying to determine the best formula to use to accomplish this. I have been using SUMIF but not sure how to get it to work with two variables

My worksheet has 3 columns: Name, Task, Minutes

I need to identify the person (Name) and then the Task (i.e. process paperwork) and then how much time they are spending on that task.

No matter what I try - I keep getting #unparseable.

Any help would be greatly appreciated.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!