SUMIFS Unparseable

Hello,

I am trying to do a SUMIFS to do the following:

-{Product Release Roadmap Intervalo 2} - it is the column "Assigned To" in the sheet "Product Release Roadmap

-"Jorge Duarte" - it is the name I want to filter

-{Product Release Roadmap Intervalo 11} - it is the column for the count time (like 3) I want to sum

-{Product Release Roadmap Intervalo 3} - it is the date column I want to filter between 01 August 2020 and 31 August 2020.

I did the following function but it is returning Unparseable.

=SUMIFS({Product Release Roadmap Intervalo 2}; "Jorge Duarte"; {Product Release Roadmap Intervalo 11}; >=DATE(2020;08;01); {Product Release Roadmap Intervalo 3},<=DATE(2020;08;31))

The goal is to sum the total hours for a person between 01 August 2020 and 31 August 2020 referring a different sheet named "Product Release Roadmap".

Can you please help me?

Thank you

Find more posts tagged with

Accepted answers

David Joyeuse

@Angela Formiga

=SUMIFS({Product Release Roadmap Intervalo 11};{Product Release Roadmap Intervalo 2}; "Jorge Duarte";{Product Release Roadmap Intervalo 3}; AND(YEAR(@cell)=2020;MONTH(@cell)=8))

All comments

David Joyeuse

Hi @Angela Formiga

You mixed semi colons and coma. Depending on your language version you should either replace the comma before the last DATE argument. Or replace every semi colon with comas :)

I guess that's the first one :)

That said, your SUMIFS isn't correctly written. It should be this:

=SUMIFS({Product Release Roadmap Intervalo 11};{Product Release Roadmap Intervalo 2}; "Jorge Duarte";{Product Release Roadmap Intervalo 3}; MONTH(@cell)=8)

Hope it helped!

Angela Formiga

Hello @David Joyeuse

thank you very much for the answer. Worked perfectly.

Just a detail, Iwant to specify the year like YEAR(@cell)=2020

How can I do it in the function below?

=SUMIFS({Product Release Roadmap Intervalo 11};{Product Release Roadmap Intervalo 2}; "Jorge Duarte";{Product Release Roadmap Intervalo 3}; MONTH(@cell)=8)

David Joyeuse

@Angela Formiga

=SUMIFS({Product Release Roadmap Intervalo 11};{Product Release Roadmap Intervalo 2}; "Jorge Duarte";{Product Release Roadmap Intervalo 3}; AND(YEAR(@cell)=2020;MONTH(@cell)=8))

Angela Formiga

Perfect

thank you @David Joyeuse

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.