How to use RIGHT() in sumproduct

[chrisk]

Hi,
Ive got the below formula to count the number of jobs (D) done by person
B24 in col. (I:I
=SUMPRODUCT((INDIRECT("'"&C$23&"'!D850")<>"")*(INDIRECT("'"&C$23&"'!I8:I50")=$B$24))
How do I account for all day jobs (want a value of 2) in Col. C which has
various time entries including "A/D" I wanted to look for the A/D using
RIGHT()but am completely stuck

Thanks

 

[Gary''s Student]

Say in A1 thru B3 we have:

xxxA/D 1
xxxqwe 3
xxxA/D 5

the formula:

=SUMPRODUCT((RIGHT(A1:A10,3)="A/D")*(B1:B10)) will display 6