Sum of Cells in different Rows

Check out the =sum formula which will let you sum any numbers in any row or field. Just indicate it in your formula. 

=sum([column title]row#, [column title]row#, [column title]row#)  Will sum individual cells. 

=sum([column title]1:[column title]5) will sum rows 1-5 of a column. 

=sum([column title]:[column title]) will sum a column but you can't put this formula in the same column because it will create a circular reference and will throw an error.

https://help.smartsheet.com/function/sum

I'm trying to do the same thing with the SUMIF formula, but do not want to specify the exact criteria name "Kate Pearson" because the names are fed in through a form. Instead, I need to reference a cell within the row to then calculate the sum of all rows with the same criteria.

Example - I want to sum all donation values in the [$Value] from an employee where their name is listed in the [EEName] column of the same row. I've been able to make this work when referencing other sheets, but I'm having trouble referencing @row and within same page columns.

Here's the formula I think should work: =SUMIF(EEName:EEName, EEName@row, $Value:$Value, 1)

What am i doing wrong?