Why is my SUMIFS formula saying incorrect argument?

dsprenger · 05/01/23

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!

Paul Newcome · 05/01/23

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 · 05/01/23

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 · 05/01/23

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 · 05/02/23

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 · 05/02/23

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

Why is my SUMIFS formula saying incorrect argument?

Answers

Help Article Resources

Categories