2 Column Criteria

tmkj20

I am getting a "#Incorrect Argument Set" for the following:

=SUMIF([Division & APC]1:[Division & APC]50, "FOP Crew Mobility", [# of Features]1:[# of Features]50, >=1)

=SUMIFS([Division & APC]1:[Division & APC]50, "FOP Crew Mobility", [# of Features]1:[# of Features]50, >=1)

I'm trying to capture: If column 1 has "FOP Crew Mobility" then sum the total # of Features in column 2 if an item is greater than or equal to 1. Any ideas?

Kelly Moore

Hey @tmkj20

The SUMIFS syntax is not what smartsheet is expecting. Try this

=SUMIFS([# of Features]1:[# of Features]50, [Division & APC]1:[Division & APC]50, "FOP Crew Mobility", [# of Features]1:[# of Features]50, >=1)

If you do not specifically need the range from rows 1 to 50 called out, you can make the formula more robust by removing all references to the row numbers in all range groups.

Will the formula above work for you?

Kelly

tmkj20

Hi Kelly:

Thank you for the quick response! I'm just seeing today! The solution I created was:

=SUMIF([Division & APC]:[Division & APC], "FOP Crew Mobility", [# of Features]:[# of Features])

But, I tested your suggestion as well and it worked! Thank you so much!