SUMIF and CONTAIN referencing another sheet

Hi Guys,

Have got lost in this one, and I think we might be close to cracking it.

I am trying to Sum the values from one column referencing a name from separate column, a little like a sales sheet.

The complexity is that I am trying to reference another sheet and I keep getting #Unpareseable

=SUMIFS({1.Groups WIP Range 1}, {1.Groups WIP Range 4}, CONTAINS("Dan Mitchell", @Cell))

This is the above formulae that I am using

Can you see anything I am missing here?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!