SUMIF and CONTAIN referencing another sheet

ProductDan

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?

Thanks

Dan

Paul Newcome

@cell should be all lower case.

Paul Newcome

@cell should be all lower case.

ProductDan

@Paul Newcome

Cant believe it was that simple! How annoying haha (Thanks Paul)

Have got a 0 now, but there should be a much higher value.

Any ideas on this one?

Paul Newcome

What exactly are you selecting for each of your ranges, and can you provide screenshots of the source data?