Hello guys,
hope you can help me with this SUMIFS:
I am creating a chart to show the daily usage in minutes for a certain condition.
So SUMIFS must verify IF in the row contains my text condition, and if yes, sum the minutes based on that specific day.
The problem here is that I have multiples dates in different columns, so SUMIFS is not working properly.
My formula: =SUMIFS(B2:B10,A2:A10,"*Red*",C2:M10,C13)
I am sure this must be easy for you guys :)
thanks in advance
Bookmarks