Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF or SUMPRODUCT
Help
I need to know how many times a job code (2E190) occurs in column C, if column D is one of 5 different office codes (CYN,CYND,CYNS,CYNT or CYNV) I used the bellow code but it doesnt seem to generate an answer in the cell Note the data is recorded on one worksheet (functional view) and the chart Im displaying the info on is on another) =SUMPRODUCT(--('Functional View'!C2:C102="2E131"),--('Functional View'!D2:D102="CYN"),--('Functional View'!D2:D102="CYND")--('Functional View'!D2:D102="CYNS")--('Functional View'!D2:D102="CYNT")--('Functional View'!D2:D102="CYNV")) Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF or SUMPRODUCT
Hi
You are missing commas between your arguments. but this would be AND'ing each of the different office codes instead of OR'ing. Try =SUMPRODUCT((C2:C102="2E131")* (D2:D102={"CYN","CYND","CYNS","CYNT","CYNV"})) -- Regards Roger Govier "tmcook" wrote in message ... Help I need to know how many times a job code (2E190) occurs in column C, if column D is one of 5 different office codes (CYN,CYND,CYNS,CYNT or CYNV) I used the bellow code but it doesn't seem to generate an answer in the cell Note the data is recorded on one worksheet (functional view) and the chart I'm displaying the info on is on another) =SUMPRODUCT(--('Functional View'!C2:C102="2E131"),--('Functional View'!D2:D102="CYN"),--('Functional View'!D2:D102="CYND")--('Functional View'!D2:D102="CYNS")--('Functional View'!D2:D102="CYNT")--('Functional View'!D2:D102="CYNV")) Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif or Sumproduct | Excel Worksheet Functions | |||
Sumproduct and Countif | Excel Discussion (Misc queries) | |||
COUNTIF or SUMPRODUCT? | Excel Worksheet Functions | |||
SumProduct or CountIf | Excel Worksheet Functions | |||
countif, sumproduct | New Users to Excel |