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

  • Anson Cheung
    Anson Cheung ✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!