sumifs

Darrin Phillips

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!

Screen Shot 2023-03-26 at 10.35.12 AM.png

Find more posts tagged with

Accepted answers

All comments

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

Darrin Phillips

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.

Genevieve P.

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.