SUMIFS Returning Zero?

I am trying to sum all hours that meet a certain criteria (match the lookup column/project ID).

My Formula:

=SUMIF({0 | Affiliate TESS HOURS}, [LOOKUP COLUMN]@row, {0 | Affiliate TESS Lookup})

{0 | Affiliate TESS HOURS} --> references "Entered Hours"

{0 | Affiliate TESS Lookup} --> References "Lookup Column"

Formula is in the last column

Source Sheet

I tried even to multiply "entered hours" by 1 to ensure "hours" is counted as a number. I referenced both of those two columns at one point and neither summed to anything other than 0.

I confirmed by COUNTIF that there are many rows that match the lookup column so that shouldnt be the issue?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!