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")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
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")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you so much! It worked!!!
-
Happy to help! 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!