Comparing multiple cells

[Dkittrell]

Hoping someone can help me out here, I’m making a tracking sheet for work. It’s for techs not doing their paperwork, btw I have about 20 techs im tracking . So I have 5 different problems that can occur that need tracking and go under the techs name. I got the code to work If there is only one problem, my issue is sometimes there will be up to 5 problems. As you see in the pic on line 4 and 5, it sees Name and Problem IP so it registered 2 under IP, but on line 6 it says IP,OP and it wont register. Ive tried writing it different ways i tried my code G3:K3 on the 2nd part of the code.


My Code so far
=SUMPRODUCT((C4:C10=F5)*(D4:D10=G3))

Cell F5 is the Techs name, the techs are F5:F43 every other row G3 is the Name of the problem, The Titles of the problems are G3:K3 . just giving the full picture

PS. Name will be changed to the actual Techs name, i just changed it to post it on here

 

[Andrew Poulsom]

Welcome to MrExcel.

Try:

=SUMPRODUCT(--($C$4:$C$10=$F5),--(ISNUMBER(SEARCH(G$3,$D$4:$D$10))))

 

[Dkittrell]

Welcome to MrExcel.

Try:

=SUMPRODUCT(--($C$4:$C$10=$F5),--(ISNUMBER(SEARCH(G$3,$D$4:$D$10))))

Thanks a lot that was exactly what i needed