SUMIFS with Reference Columns?

Hi Everyone,

I am stuck on a scenario that I need assistance with.

I have a sheet to track project tasks. (screen # 1). In this sheet, I have a formula to calculate hours per person per month and it works great.

I would like to move this formula to a helper-sheet (screen # 2) so I can run reports on it.

However, when I attempt to run the same formula (and adjusting the column names), I can't get the formula to populate the information properly in the helper-sheet. Is there a restriction or a special way to run the SUMIFs formula with referenced columns?

Thank you in advance for any guidance.

Screenshot # 1 (Src Sheet)

Screenshot # 2 (Helper-Sheet)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!