2003 Limitation?

[Rogerisit]

=SUMPRODUCT(--(Attendance!A6:A381<=Bob!A5),--(Attendance!A6:A381>=Bob!A5-6),--(Attendance!B6:B381=Attendance!$D$2))+(SUMPRODUCT(--(Attendance!A6:A381<=Bob!A5),--(Attendance!A6:A381>=Bob!A5-6),--(Attendance!B6:B381="?/Attendance!d2"))*0.5)+(SUMPRODUCT(--(Attendance!A6:A381<=Bob!A5),--(Attendance!A6:A381>=Bob!A5-6),--(Attendance!B6:B381="Attendance!d2/?")*0.5))

I am working with 2003 hence many limitations. This formula works except for "Attendance!d2/?" & "?/Attendance!d2" which returns no value. (This is where an employee has a half day such as A/P or S/A (Annual, Sick, Present) In D2 we have the "A.")

I know that "Attendance!d2/?" works in a countif, so I'm wondering if this is just a 2003 limitation or are you able to help with how this can be rectified.

Thanks kindly

 

[Rogerisit]

=SUMPRODUCT(($G$5:$AK$5<=$E$2)*($G$5:$AK$5>=$E$2-6)
* ISNUMBER(SEARCH(B$3,$G6:$AK6)) * (0.5 + (ISNUMBER(SEARCH("/",$G6:$AK6))=FALSE)*0.5))

This worked brilliantly.
Thank you so very much