Why is this #incorrect argument set

RickyT

=SUMIF([Task Status]:[Task Status], "Completed", [Contact(s)]:[Contact(s)], " ricky torres ")

I'm trying to show the completed tasks in the contacts column, and specifically for the contacts individually.

Find more posts tagged with

Formulas

Accepted answers

Eric Law

@RickyT Ok, so you will need the COUNTIFS formula, not the SUMIF since you have 2 criterion and since there are no numbers to add.

=COUNTIFS([Task Status]:[Task Status], "Completed", [Contact(s)]:[Contact(s)], " ricky torres ")

All comments

Eric Law

@RickyT I am confused about what you are trying to do. Please post a screen shot. From your description of what you are trying to do and the formula you used, it is confusing.

RickyT

@Eric Law here is the screenshot with the formula in the bottom right

RickyT

If the task is complete and also done by ricky torres, then add it up

Eric Law

@RickyT Ok, so you will need the COUNTIFS formula, not the SUMIF since you have 2 criterion and since there are no numbers to add.

=COUNTIFS([Task Status]:[Task Status], "Completed", [Contact(s)]:[Contact(s)], " ricky torres ")

RickyT

Thanks for the help @Eric Law

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.