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

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