Sumifs formula help please

Trying to determine # of total hours if a specific program is listed. Seems simple but keep getting errors. Attempts below. Any thoughts?

=SUMIFS({Team Range 9}, >0, ({Team Range 8}, FIND("Program", @cell) =true))

=SUMIFS({Team Range 9}, >0, {Team Range 8}, [\[Formula descriptor 2\]]@row)

Find more posts tagged with

Accepted answers

Try something like this...

=SUMIFS({Hours Column}, {Program Column}, "Program")

Perfect! Thanks!!

All comments

Try something like this...

=SUMIFS({Hours Column}, {Program Column}, "Program")

Perfect! Thanks!!

Happy to help. 👍️

Hey Paul, what if "program" is blank.

On the source sheet or the sheet holding the formula?

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.