sumifs
Hello, I am trying to sum project hours by project per month and seem to be missing something.
I am trying to use: =SUMIFS(Hours:Hours, Project:Project, "HGI Condado", Month:Month, "January")
But this formula yields "invalid data type". Not sure what I did wrong. nay help would be great!
Answers

Hi Darrin, Your formula should be correct. One of the possible causes is that your source columns contain an error. If needed, wrap them by IFERROR() E.g.
Anson

Thanks Anson! There are no errors that I can find. This is a sheet that has rows auto sent to it from a number of other sheets so I was not sure if that was the issue.

Hey @Darrin Phillips
The structure of your formula is correct so there's something else going on here  to troubleshoot, can you try summing the entire column without any other criteria?
=SUM(Hours:Hours)
If that errors, then it lets us know we need to check out the Hours column, for example if the values are coming through as text instead of numerical.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!