SUMIFS 3 criterias

Hi,

I'm trying to create a formula with 3 criteria but it doesn't work.

Here it is:

=SUMIFS({Hours (1)}, {Période de paie ING}, [Période de paie]@row, {Centre de coûts Projets 1}, [Numéro de projet]@row, {Colonne Employee name}, {Alberto})

When I remove one of the criteria (no matter which one), the formula works well! I don't get it...

Find more posts tagged with

Accepted answers

All comments

Ramzi K

I think your issue is that {Alberto} in your formula is not a criteria. You need to point to a cell or a value instead of a range (assuming that {Alberto} is pointing to a range in another sheet).

Notice how [Période de paie]@row for criteria 1 and [Numéro de projet]@row for criteria 2 are values whereas {Alberto} is probably pointing to a range in another sheet.

I hope that helps.

Ramzi

Julie Barbeau

Hi Ramzi,

{Alberto} point a cell in another sheet (complete name)

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.