Just did it, based on your data, but in the array formula i referenced a cell
with the part # and location in and it worked.

{=SUM((A1:A2=A1)*(B1:B2=B1)*(C1:C2))}

a = location, b = part#, c= qty

hope this helps.


"Bob" wrote:

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