COUNTIF or SUMPRODUCT

[Guest]

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'!D2102="CYN"),--('Functional View'!D2102="CYND")--('Functional
View'!D2102="CYNS")--('Functional View'!D2102="CYNT")--('Functional
View'!D2102="CYNV"))

Thanks in advance

 

[Roger Govier]

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")*
(D2102={"CYN","CYND","CYNS","CYNT","CYNV"}))