Sumifs error formula when summing duration time

HI, I have a metric sheet where it is comparing to see person exists on another sheet and if so calculate the durations assigned against all their tasks.

I get an #UNPARSEABLE in the formula that I cant figure out. Can anyone advise?

=SUMIFS({Michael Johnson Assigned to}, [IT Personnel w no Email]@row, {Michael Johnson duration}, >1)

This is my target sheet

This is my source sheet

Thanks

Find more posts tagged with

Accepted answers

DKazatsky2

Hi @Graeme Baxter,

Try changing your formula to this: =SUMIFS({Michael Johnson duration}, {Michael Johnson Assigned to}, [IT Personnel w no Email]@row, {Michael Johnson duration}, @cell > 1)

I am assuming you are failing on {Duration} because you don't have that as a reference.

Hope this helps,

Dave

All comments

Bassam Khalil

Hi@ Graeme Baxter,

please try the following formula :

=SUMIFS({Duration}, {Assign To}, [IT Personnel w no Email]@row, {Duration}, @cell > 1)

the following is the database sheet :

and this is the target sheet:

Graeme Baxter

@Bassam Khalil

Appreciate your time.

I did as you suggested but I get a #INVALID REF

=SUMIFS({Duration}, {Michael Johnson Assigned to}, [IT Personnel w no Email]@row, {Michael Johnson duration}, @cell > 1)

Do I have something wrong here?

DKazatsky2

Hi @Graeme Baxter,

Try changing your formula to this: =SUMIFS({Michael Johnson duration}, {Michael Johnson Assigned to}, [IT Personnel w no Email]@row, {Michael Johnson duration}, @cell > 1)

I am assuming you are failing on {Duration} because you don't have that as a reference.

Hope this helps,

Dave

Graeme Baxter

@DKazatsky2

That worked. Thank you so much for your help. Much appreciated.

Graeme

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.