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