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.

Quantity</SPAN>	(A)	Condition (B)</SPAN>		Disposal Date (C)</SPAN>
2</SPAN>		Good</SPAN>	</SPAN>
3</SPAN>		Good</SPAN>
1</SPAN>		Good</SPAN>		7/19/2012</SPAN>
1</SPAN>		Bad</SPAN>
2</SPAN>		Good</SPAN>
5</SPAN>		Good</SPAN>
1</SPAN>		Good</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>

 

[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=""))