Sum formula for multiple criteria... help?
 

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

Sum formula for multiple criteria... help?
 

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