Sum formula for multiple criteria... help?

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help Writing a SUM Formula 5
Excel formula, sum the value cell and if empty cell left blank 0
Multiple Criteria in Sum if Formula 2
Multiple criteria for sumproduct 4
using if for multiple criteria 22
Dynamic Sum Array Formula Input Help 3
Total or Count based on multiple conditions 4
Conditional sum on an array based on another array 3

Back
Top