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)