SUMIF

Richard Grimes

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]

rgochee

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])

Richard Grimes

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?

rgochee

@Richard Grimes,

Try putting both Columns to a Contact List "Assigned To" and "Person"

Rob

Richard Grimes

Still showing 0, :(

rgochee

@Richard Grimes

Do you mind snipping a screen shot columns and your formula.

Richard Grimes

Andrée Starå

@Richard Grimes

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!

Richard Grimes

Thats helped, thank you for your help.

Take care

Andrée Starå

@Richard Grimes

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!