All,

Currently I'm trying to calculate values based on the following (and having
zero luck): I have a sheet with multiple part numbers and global locations,
and the associated quantities. So it might read:

Zimbabwe | 95-049563-01 | 3
Taiwan | 95-049563-01 | 2

The last thing I was able to find online was an array formula using sums,
which looked like so:
{=SUM((A2:A7807="Zimbabwe")*(C2:C7807="95-049563-01")*G2:G7807)}

I don't get an error when I complete this, but it always tallies to zero.
I'd appreciate any help anyone can give at all. Thanks!

Sincerely,

Bob