SUMIFS not working (referencing another sheet)

Genevieve P.

Heya! I don't know of any changes, that's interesting.

I do know that values with leading 0s can sometimes be missed by COUNT or SUM formulas, which is fixed by using @cell = [content] instead of just [content].

Paul Newcome

@Genevieve P. Thanks! I feel like we tried the @cell reference in the other thread though and still had to use the VALUE function to convert to numbers instead of the [Column Name]@row + "" to convert to text. I can't remember. Ugh.

When I am writing my own formulas I ALWAYS use "@cell" references though, so I do tend to forget that not using them can sometimes cause issues.