Thanks for the reply, Luke. SUMPRODUCT treats non-numeric entries as zero so
I keep getting a zero result.

The way lined up in my example was a bit misleading....this is my real-life
example:

Aug Sep
------ ------
Dept Shift ST OT ST OT
------ ------- ------ ------ ------ -------
443 1st 493 41 986 81
443 2nd 493 41 986 81
443 3rd - - - -
444 1st 141 16 282 32
444 2nd 141 16 282 32
444 3rd - - - -
445 1st 422 48 845 102
445 2nd 352 40 704 85
445 3rd - - - -
448 1st 211 15 422 30
448 2nd 282 20 563 40
448 3rd 70 5 141 10
449 1st 563 27 1,126 55
449 2nd 422 21 845 41
449 3rd 70 3 141 7

this is an exerpt from a large table of straight-time and overtime by month,
dept and shift. I want to be able to pull data from this (just one
intersection point) into other spreadsheets given the month, dept, shift and
whether ST or OT. What is that formula in the other spreadsheets?

"Luke M" wrote:

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?