excelNewbie007
New Member
- Joined
- Jul 25, 2012
- Messages
- 2
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.
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>
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>