SUMIF - #Incorrect Argument Set

Hi - the formula below is returning an error - #Incorrect Argument Set.

In summary if the WP Lead = 'Bob Smith' and PO Name = 'US - Merchant' then I need to add up the total headcount for such items within the corresponding column called 'Total FTE Equiv'.

=SUMIFS([WP Lead]:[WP Lead], "Bob Smith", [PO Name]:[PO Name], "US - Merchant", [Total FTE Equiv.]:[Total FTE Equiv.])

NB: all of the data above is contained within the same SmartSheet.

Thanks in advance,

Steve

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    edited 11/14/23 Answer ✓

    Hey @Stephen Halsey

    The syntax of your SUMIFS isn't what smartsheet is expecting. The column you wish to sum needs to be the first in the list.

    =SUMIFS([Total FTE Equiv.]:[Total FTE Equiv.],[WP Lead]:[WP Lead], "Bob Smith", [PO Name]:[PO Name], "US - Merchant")

    Will this work for you?

    Kelly

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!