SUMIF - #Incorrect Argument Set

Stephen Halsey

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

Kelly Moore

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

Kelly Moore

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

Stephen Halsey

Hi Kelly,

Thanks for the guidance above - that worked.

Stephen