Summary Sheet calculate column totals


In the Sheet Summary section, I want to calculate three column totals. I have the below formula that is recognising the columns as 0, but if I add hours to any of the referenced columns, it does not add.

=SUMIFS([Travel To Site]:[Travel To Site], [Travel Site To Site]:[Travel Site To Site], [Travel From Site]:[Travel From Site])

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!