SUMIF on separate Sheet

Saramitsu

Hi, I'm new to the community and fairly new to Smartsheet and already hit a wall and finally decided to reach out to the community for assistance!

I have a sheet with one column called "Broker" with approximately 30 names and one column called "Commission". My goal is to be able to calculate on a separate sheet total commission for each specific Broker their individual total commission and I thought SUMIF would be the formula to use - however, it keeps giving me the error message... Below is a simple screenshot. Could anyone help me with the correct formula?

Thank you very much for your help!

Paul Newcome

Welcome to Smartsheet and the Community!

The formula you are going to want to use will look something along the lines of...

=SUMIFS({Other Sheet Commission Column}, {Other Sheet Broker Column}, "John Doe")

Paul Newcome

Welcome to Smartsheet and the Community!

The formula you are going to want to use will look something along the lines of...

=SUMIFS({Other Sheet Commission Column}, {Other Sheet Broker Column}, "John Doe")

Saramitsu

Thank you so much! It worked!!!

Paul Newcome

Happy to help! 👍️