SUMIF using CONTAINS from a different sheet

SUMIF using CONTAINS from a different sheet

Hello!

I am trying to sum from a certain column when another column contains the word "RSMAS", this is what I am trying and it doesn't seem to work:

=SUMIF({Completed Request - Safe Return to Campus Range 2}, CONTAINS("RSMAS", {Completed Request - Safe Return to Campus Range 3}))

Any ideas?

Thank you!!

Best Answer

Answers

Sign In or Register to comment.