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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!