Summing with Multiple Criteria --> Sum Changes with Filter

[excelNewbie007]

I'm trying to find the visible sum of the QUANTITY of GOOD units that aren't DISPOSED yet. If I decide to filter any of the other columns, I want the sum to change accordingly since I'm looking for the visible sum.

Range I want to sum: QUANTITY
A2:A1000

Criteria: CONDITION & DISPOSAL DATE
B2:B1000 = "Good"
C2:C1000 = " "

Notes:
Only sum visible cells, depending on if I apply the filter.

The only functions I know that only measure visible cells are SUBTOTAL and SUMPRODUCT. I've been playing around with these functions, but I can't seem to get it. Like I tried using subtotal(9,____). In the ____, I tried to write a function that followed the criteria AND returned a range, but I was unable to find that. I'm not familiar with pivot tables or name ranges, so if it's possible, stray away from those.

[TABLE="width: 696"]
<TBODY>[TR]
[TD]Quantity</SPAN>[/TD]
[TD](A)[/TD]
[TD]Condition (B)</SPAN>[/TD]
[TD][/TD]
[TD]Disposal Date (C)</SPAN>[/TD]
[/TR]
[TR]
[TD]2</SPAN>[/TD]
[TD][/TD]
[TD]Good</SPAN>[/TD]
[TD]</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3</SPAN>[/TD]
[TD][/TD]
[TD]Good</SPAN>[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1</SPAN>[/TD]
[TD][/TD]
[TD]Good</SPAN>[/TD]
[TD][/TD]
[TD]7/19/2012</SPAN>[/TD]
[/TR]
[TR]
[TD]1</SPAN>[/TD]
[TD][/TD]
[TD]Bad</SPAN>[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2</SPAN>[/TD]
[TD][/TD]
[TD]Good</SPAN>[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5</SPAN>[/TD]
[TD][/TD]
[TD]Good</SPAN>[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1</SPAN>[/TD]
[TD][/TD]
[TD]Good</SPAN>[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>[/TABLE]

 

[T. Valko]

I tried this and I got 0 as a result...It should be 13.

Maybe the column C criteria is supposed to be: If C2:C1000 = blank/empty.

Try this...

=SUMPRODUCT(SUBTOTAL(9,OFFSET(A2,ROW(A2:A1000)-ROW(A2),0)),--(B2:B1000="Good"),--(C2:C1000=""))