Help with poss SUMIF? remove comma

[ffman]

Hey everyone,
hope all is well and happy early Thanksgiving.. I need some help.. I'm creating a spreadsheet where when someone is dispatched (it may be multiple people) you select the drop down and it enters there name, but it adds comas at the end of there name (except the last name). and enter the hours they all went. Say whoever I select for that name, and in that same line. I want who ever was select that time, those hours to goto them.. I have it kind of working but only when I select one person at a time.. When I try to select multiple, it wont search it because of the comma.

Here is what i'm using to get the total of numbers PER user
=SUMIF(J4:J10,A13,$I4)

The J4:J10 is the drop down / A13 is just a list of employees, $I4 is hours spent on the call..

I can send the spreadsheet if needed. Not sure how on here? Please help .. If I can figure a way for the sumif to ignore the comma in J4, it would work...

 

[jorismoerings]

Hi,

could you post a sample set of data it's difficult to help without a clear view on the data.

 

[barry houdini]

Assuming that A13 contains an entry like Bob,Dave,Gavin and J4:J14 contains single names then try this formula to sum for those names

=SUMPRODUCT(ISNUMBER(SEARCH(","&J4:J14&",",","&A13&","))+0,I4:I14)

​

​