Sumproduct not sumproducting!

[skitsoni]

I want to reference the number of times a dept number is listed (on an adjacent tab) by its variable "CIP" and return that count on the current tab.

The below formula is my attempt but it returns "0" (even when entered as an array)

=SUMPRODUCT(IF(BA04_Emps!$C$2:$C$132=A45,IF(BA04_Emps!$F$2:$F$132="CIP",)))

Much appreciation for any help on this!

 

[VoG]

Try

=SUMPRODUCT(--(BA04_Emps!$C$2:$C$132=A45),--(BA04_Emps!$F$2:$F$132="CIP"))

 

[skitsoni]

Thanks for the quick reponse but still returning "0". I see where you made the adjustment and I think it's pretty close at this point.

 

[VoG]

Which sheet is A45 on?

 

[skitsoni]

It's on a sheet called "CIP Report" which is the same sheet where I would like to return the answer (column Q)

Thanks,
SK

 

[xenou]

Maybe:
=CountIf(BA04_Emps!$F$2:$F$132="CIP")

(?)

Otherwise, explain what's in these ranges (I'm not sure why column C and column F are both involved here, or what's in A45):
BA04_Emps!$C$2:$C$132
BA04_Emps!$F$2:$F$132
'CIP Report'!A45