How to use RIGHT() in sumproduct
Hi,
Ive got the below formula to count the number of jobs (D:D) done by person
B24 in col. (I:I)
=SUMPRODUCT((INDIRECT("'"&C$23&"'!D8:D50")<"")*(I NDIRECT("'"&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
|