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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!