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!
Answers

Is that error present in any cell being referenced by the formula?
Are you able to provide the COUNTIFS formula that you have working?

There is not. Everything can be referenced elsewhere without issue.
Here's a corresponding COUNTIFS: =COUNTIFS({MasterLead}, =$Chemist@row, {MasterRDCat}, ="PMO")

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.

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!

It may have just been some latent data on the backend. Glad it is working for you now though.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!