SUMIFS Help

[steveo0707]

Hello,

I am using SUMIFS to extract data from a table. I am trying to get the formula to work with two conditions instead of one and its returning zeros for the sum and the Discrepancy type is not displaying in the table.

The formula in the formula bar is in cell P20.

 

[RoryA]

The 0 appears correct as there doesn't appear to be anything in the Type column of your summary table.

 

[steveo0707]

The 0 appears correct as there doesn't appear to be anything in the Type column of your summary table.

That's what I'm trying to get Fixed. How do I change the formula to get the machine number and the discrepancy type to appear.

 

[RoryA]

That formula will not return either. It only returns the sum of the relevant numbers.

 

[steveo0707]

That formula will not return either. It only returns the sum of the relevant numbers.

How would I scan the table and return the information I'm looking for.?

I'm trying to figure out how to get Total pieces rejected for Machine Number 205, and any and all Discrepancy Types with their sums (i.e., Burrs, Thread issue) associated only to 205.

 

[RoryA]

How did you create the list in column N? Manually?

 

[steveo0707]

How did you create the list in column N? Manually?

No, that is done with an SUMIFS Formula, =SUMIFS(Table1[Number Rejected (Corrected)],Table1[Discrepancy Type],[@Type])

 

[RoryA]

That formula could not possibly produce the list of Machine numbers in column N.

 

[steveo0707]

Machine Numbers are Manually entered, Sorry.

 

[RoryA]

If you are using 365, I suggest you ditch your table and use a UNIQUE formula to get a unique list of the machine number/type combinations, then use your SUMIFS alongside that. If you have HSTACK available, you can produce the entire summary with one formula.