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
Check out the Formula Handbook template!