Sum on conditions help

[ChaosPup]

Hi all,

I'm struggling with a formula, hopefully someone can help.

I have 3 columns - QTY, TYPE and PASS/FAIL. TYPE is a dropdown with 3 options (SUBASSY, FINAL, INSPECTION). PASS/FAIL is a dropdown with 2 options (PASS, FAIL). QTY can be any whole number.

What I want to do is sum the QTY column for the rows where TYPE is SUBASSY and PASS/FAIL is FAIL.

I was initially using COUNTIFS but obviously this didn't count properly.

All help welcome.

Thanks!!

 

[Fluff]

I was initially using COUNTIFS but obviously this didn't count properly.

What was the formula & in what way didn't it count properly?

 

[ChaosPup]

I was using

=COUNTIFS('2023 INSP AUDIT'!$F$4:$F$11,$O$4,'2023 INSP AUDIT'!$G$4:$G$11,$M$2)

, but it would only sum the amount of times FAIL appeared because I didn't know how to reference the QTY column that I want to sum.

 

[Fluff]

Ok, thanks for that, which col is the Qty in?

 

[ChaosPup]

Apologies, I should have indicated that. The QTY is in column D4 to D11 on sheet 2023 INSP AUDIT

 

[Fluff]

Ok, how about

=SUMIFS('2023 INSP AUDIT'!$D$4:$D$11,'2023 INSP AUDIT'!$F$4:$F$11,$O$4,'2023 INSP AUDIT'!$G$4:$G$11,$M$2)

 

[ChaosPup]

Ok, how about

=SUMIFS('2023 INSP AUDIT'!$D$4:$D$11,'2023 INSP AUDIT'!$F$4:$F$11,$O$4,'2023 INSP AUDIT'!$G$4:$G$11,$M$2)

That looks like it did the trick, thanks very much!

 

[Fluff]

You're welcome & thanks for the feedback.