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
-
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")
Answers
-
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")
-
Thank you so much! It worked!!!
-
Happy to help! 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!