A sumproduct would be more suited to your needs I think but without more details it's hard to tell. Give more details of your setup like spreadsheet names, ranges of your data, stuff like that and I'm sure you'll get an answer to your problem.

Regards
JG