SUMIF
Hello, I am trying to create a sumif formula to work out a value of column each time a name appears in a different column. I am currently using the below but it keeps coming back with #UNPARSEABLE
=SUMIF([Assigned 1st]:[Assigned 1st], "[Nicola Sutton]", [Job Value]:[Job Value]
Answers
-
Richard,
You can write this a couple way's - Once by manually using the name as the reference "Nicola" =SUMIF([Assigned 1st]:[Assigned 1st], "Nicola", [Job Value]:[Job Value]) or you can automate the formula by using an @row referencing the cell with the persons name =SUMIF([Assigned 1st]:[Assigned 1st], Person@row, [Job Value]:[Job Value])
-
rgochee- Thanks for your help,
I have used this formula and now is comes up with 0, when I use their full name. But when I change the assigned 1st column to just using their first name it works. Will SUMIF only work on singular names?
-
-
Still showing 0, :(
-
Do you mind snipping a screen shot columns and your formula.
-
Hi Richard,
Here are two options. One with the name in the formula and one which reference another cell with the name in it.
Try something like this.
NAME
=SUMIF([Assigned 1st]:[Assigned 1st]; "Nicola Sutton"; [Job Value]:[Job Value])
The same version but with the below changes for convenience.
=SUMIF([Assigned 1st]:[Assigned 1st], "Nicola Sutton", [Job Value]:[Job Value])
REFERENCE
=SUMIF([Assigned 1st]:[Assigned 1st]; [Assigned 1st]@row; [Job Value]:[Job Value])
The same version but with the below changes for convenience.
=SUMIF([Assigned 1st]:[Assigned 1st], [Assigned 1st]@row, [Job Value]:[Job Value])
Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.
Did that work?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thats helped, thank you for your help.
Take care
-
Excellent!
I'm always happy to help!
✅Remember! Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
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!