# Find Smallest Number With Multiple Criteria

Sep 2, 2008I need a formula that will give me the smallest number based on multiple criteria.

For example, I want to find all:

1. Product A

2. 1 Liter

3. Smallest Price

In other words, out of all 1 Liter Product A's, I want to see the smallest price point.

I tried a sumproduct but I can't get it to work. Something like =sumproduct((A1:A100="Product A")*(B1:B100="1L")*(small(C1:C100,1)))

How can I get the small formula working within the sumproduct? Or is there another workaround?