You can use SUMPRODUCT for multi-conditions. For red fruit from store1 in
january something like:
=SUMPRODUCT(--(A2:A100="January"),--(B2:B100="Store1"),--(C2:C100="Fruit"),(D2:D10))

This assumes month is in column A, store in column B, Type in column C, and
inventory is in column D. Try playing around with the different critieria to
get what you need. Note that the arrays need to be same size, and unless
using XL 2007, you can't callout entire column (A:A).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"44judester" wrote:

Variables from which to choose: Month, Store#, Type (Fruit or Veg), Color

Table looks like this:
Fruit
Vegetable
Month Store# Red Green Orange Red Green Orange




The data is the inventory of red fruits, green vegetables, etc in each store
at the end of each month.

What does my formula look like to lookup that inventory volume for a given
set of variables?