Can Smartsheet add SUMIF statements together? Struggling!

Mary Anne Dunn

Hi all -

I have successfully created a column with two cross-sheet references. The Concatenate Row adds the brokers name and the MM - YYYY.

=SUMIF({Invoices Range - Broker 1}, Concatenate@row , {Invoices - Rev to Broker 1})

I want to add multiple SUMIF formulas together here is the formula I tried and getting error message INVALID OPERATOR. Is there some obviously wrong below? OR can you now add two SUMIF statements together, is there an option you would suggest?

=SUMIF({Invoices Range - Broker 1}, Concatenate@row , {Invoices - Rev to Broker 1} + =SUMIF({Internal Broker 2}, Concatenate@row , {Rev to Broker 2}))

Thank you!

Mary Anne

Anjanesh Vaidya

Hi @Mary Anne Dunn,
Your formula has some syntax errors. First, you need to close the parentheses for the first SUMIF. Second, there’s no need to use an = sign in between the functions.

Please use the formula below:

=SUMIF({Invoices Range - Broker 1}, Concatenate@row , {Invoices - Rev to Broker 1}) + SUMIF({Internal Broker 2}, Concatenate@row , {Rev to Broker 2})