Why is my SUMIFS formula saying incorrect argument?

I'm working on a metrics sheet to power a dashboard. I want to sum our effort values for each of our chemists and each of our project categories.

My ranges are:

{MasterLead} : Column listing chemist on project

{MasterEffort} : Column of effort values for each project

{MasterRDCat} : Column of project categories

I am trying to use the following formula:

=SUMIFS({MasterEffort}, {MasterLead}, =$Chemist@row, {MasterRDCat}, ="PMO")

From what I understand, this formula will sum effort values from {MasterEffort} where {MasterLead} is the chemist for the row and where {MasterRDCat} is PMO.

I am able to work with these ranges when using COUNTIF, but I'm having a lot of trouble using SUMIF. Thank you!

Find more posts tagged with

Sheets

Formulas

Dashboards

Accepted answers

All comments

Paul Newcome

Is that error present in any cell being referenced by the formula?

Are you able to provide the COUNTIFS formula that you have working?

dsprenger

https://community.smartsheet.com/discussion/comment/373935#Comment_373935

There is not. Everything can be referenced elsewhere without issue.

Here's a corresponding COUNTIFS: =COUNTIFS({MasterLead}, =$Chemist@row, {MasterRDCat}, ="PMO")

Paul Newcome

Double check your {MasterEffort} range to ensure that it is in fact only covering one column (and covering the full column) the same as the other two ranges.

dsprenger

https://community.smartsheet.com/discussion/comment/373956#Comment_373956

I double checked and it was. However, it seems to be working just fine today. I'm not sure what changed, but I'll take it.

Thanks for your help!

Paul Newcome

It may have just been some latent data on the back-end. Glad it is working for you now though.

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.