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.
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!