Please Help with Summit Formula

David Metzler
edited 12/09/19 in Smartsheet Basics

I want to if assigned person is correct  to then take information from one cell  and transfer to a different cell automatically? 

This is the formula I have so far however when I enter this it gives the #unparseable error

=SUMIF([Fielder Assigned]:[Fielder Assigned],"Name",[Rural Mileage]:[Rural Mileage)