Sum If and Contain Formula

Mkaur

Hello,

I am trying to figure out how many hours imp manager is working for an assigned project.

This formula works: =SUMIF({Implementation Opportunities Range 9}, "A", {Implementation Opportunities Range 10}

However, I tried to apply it to a new sheet where the imp manager is a multiple drop down and more than one manager can be selected per project. It's only picking up the cells that JUST have the "A" manager.

I tried to use CONTAINS and came up with this, but its not working:

=SUMIF({Implementation Opportunities Range 9}, {Implementation Opportunities Range 10}, Contain("A", @cell))

Any suggestions?

MedaUser

Actually, try this @Mkaur:

=SUMIF({Implementation Opportunities Range 9}, HAS(@cell, "A"), {Implementation Opportunities Range 10})

MedaUser

Hi @Mkaur,

What is the Column Type for your manage column? Is it a Contact List or Dropdown list?

MedaUser

Actually, try this @Mkaur:

=SUMIF({Implementation Opportunities Range 9}, HAS(@cell, "A"), {Implementation Opportunities Range 10})

Mkaur

@MedaUser Thank you for your suggestion, that worked for me :)!

MedaUser

No problem! Happy to help!