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 back-end. Glad it is working for you now though.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!