I'd like the formulas to update based on the filtered data I have in my table. In the example, if I choose under column C "Date Shipped" all January dates I would want the quantities in A2:A4 to update. Then if I choose February update again and so on. I've been using a variety of various attempts but nothing has worked. The example sheet is attached and thanks in advance!