Converting CountIf to SumProduct

[mmontgomery]

Hello! I have looked up and tried every link and suggestions already on line that I could. Unfortunately, I'm still having trouble converting a CountIf function to SumProduct. I'm doing this because I need to link my CountIf to a closed worksheet.

My original CountIf function:
COUNTIFS(FileName!$A:$A,"71662",FileName!$M:$M,">=4366",FileName!$E:$E,"="&E$3

SumProduct not working function:
SUMPRODUCT(FileName!$A2:$A1000="71662")*(FileName!$M2:$M1000>="43466")*(FileName!$E2:$E100=E$3)

Any suggestions would be greatly appreciated, thanks!

 

[Joe4]

Welcome to the Board!

Try taking the numbers out of quotes. Quotes mean literal text, not number (so unless it is actually a numeric string, lose the quotes).
Try:

[COLOR=#333333]=SUMPRODUCT((FileName!$A2:$A1000=71662)*(FileName!$M2:$M1000>=43466)*(FileName!$E2:$E1000=E$3))[/COLOR]