SUMIF(S) Not Working

Smartsheet community,

I am having trouble with adding up a column of hours based on who the task is assigned to. Ihave a metrics sheet to use to populate the dashboards i have created.

=SUMIFS({BI/BA Team Projects Range 8}, {BI/BA Team Projects Range 1}, Item89)

{BI/BA Team Projects Range 8}= the column the numbers are located in

{BI/BA Team Projects Range 1= Assigned to Column

Item89= the persons name in the metrics sheet.

It was working but now I am getting a circular reference error and I cannot figure out what went on.

Thank you in advance for any assistance.

Answers