Hi

I want to add the cells in a column (let's assume column "C") that contains hours and minutes in a new column (let's assume column "D") if two criteria are met:

1) If column "B" contains either "val" or "45x" (usually in the beginning but can also be in the middle of the string)

2) Column "A" is a date column which spands over a week. The numbers are added only for the specific date.

I was thinking of using the sumifs() function (which would be useful because it contains if-statements that I can use for the first and second criteria) , but I have trouble with the 1) criteria.

Any suggestions?

Thx!