SUMIF on separate Sheet

SUMIF on separate Sheet

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!

Best Answer


Sign In or Register to comment.