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!
Bookmarks