Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
Sumproduct Help PLEASE | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Can Sumproduct do this? | Excel Worksheet Functions |