Hi,
here is my formula
=SUM(SUMIFS(Data!$AG$7:$AG$2688,Data!$D$7:$D$2688,$F$2,Data!$O$7:$O$2688,">="&$D39,Data!$O$7:$O$2688,"<="&$E39,Data!$M$7:$M$2688,{"*Amber*","*Red*"},Data!$N$7:$N$2688,{"*Amber*","*Green*"}))
The value returned is 15:00
When i manually filter on the database using the values in the formula the return is 10:28
The columns M and N contain Amber,Green,Grey and Red, i wish my formula to give me a total based on the colours i set in the formula above, along with the other criteria set
Data1.PNG
Data2.PNG
Sheet1.PNG
not sure if my image attachments work
Bookmarks