2 Column Criteria

tmkj20
tmkj20 Overachievers
edited 05/20/23 in Smartsheet Basics

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?

Answers

  • Kelly Moore
    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
    tmkj20 Overachievers

    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!