C
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
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