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 |
How to use RIGHT() in sumproduct
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 -- Gary''s Student - gsnu200839 "chrisk" wrote: 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 |
All times are GMT +1. The time now is 05:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com