Hello,
I hope I've understood your question and please excuse me because I'm French so I don't speak very well ...
May be with this formula in cell M12:
Code:
=SOMMEPROD(((JOUR('Expense Report Page 2'!$A$23:$A$38)=$A12)+(JOUR('Expense Report Page 2'!$A$23:$A$38)=$B12))*(('Expense Report Page 2'!$C$23:$C$38="P/T")+('Expense Report Page 2'!$C$23:$C$38="O"))*('Expense Report Page 2'!$B$23:$B$38))
In english I think it is:
Code:
=SUMPRODUCT(((DAY('Expense Report Page 2'!$A$23:$A$38)=$A12)+(DAY('Expense Report Page 2'!$A$23:$A$38)=$B12))*(('Expense Report Page 2'!$C$23:$C$38="P/T")+('Expense Report Page 2'!$C$23:$C$38="O"))*('Expense Report Page 2'!$B$23:$B$38))
Hope it will help you.
m