How can I sum values for a specified column when part of a text is included in other column cells?

Karol

Dear community

I'm stuck with a small problem. I have column with values (hours worked) and an column which contains different names of employees. I would like to sum the values (hours) for an employee. My problem is, that for a value there can be 2-3 names in the cell of the name column (employees worked together on the same matter).

=SUMIFS([hours.]:[hours.], employee:employee, "*Karol*")

didn't work out.

How can I specify/search text parts in a cell if a cell contains more than one name?

How can I specify that hours are summed up only for a specific month (January, February ..)? A date column is available.

Thank you very much.

Best regards

Karol

Karol

Dear Purnima

Thank you very much and also a happy New Year to you.

In the meanwhile I found a possibility and the following worked for me:

row wise:

=IF(FIND("Karol", Employee@row) > 0, [Hours worked]@row, 0)

then sum up.

direct sum, e.g. for december:

=SUMIFS([Hours worked]:[Hours worked], Employee:Employee, FIND("Karol", @cell) > 0, Date:Date, MONTH(@cell) = 12)

Best regards

Karol