SUMIF(S) Not Working

Carl Vieira

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.

John Jonassen

Hi @Carl Vieira

It looks like you only have criterion that you would like to meet, so would SUMIF better serve you in this case?

What if you were to try:

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

Carl Vieira

@John Jonassen thank you for this but am still getting a #circularreference error message when I use your suggested re-write.

Carl Vieira

@John Jonassen I reformatted my formula in the metrics sheet I created and it worked great!

Thank you!

Mike Wilday

Hi Carl, here is some more information on Circular Reference:

https://help.smartsheet.com/articles/2476176-formula-error-messages#toc--circular-reference