How to use RIGHT() in sumproduct

C

chrisk

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")<>"")*(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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top