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
Check out the Formula Handbook template!