What did you enter for the monthrange and the type range?
if you entered these as stated, you would get a "Name" error
if say they are in sheet 1 with the months in column A and the Parts in
column B with 100 rows of data

and your summery information is in sheet tow with the individual parts list
being in Column A starting row two, while the months owuld be in row 1
starting in Column B
in Cell B2
=sumproduct(--(Sheet1!$A$1:$A$100=$C$1),--(Sheet1!$B$1:$B$100 = $A2))
copy this equation down for all of the products and across for all of the
months.

"Jennie" wrote:

hi all,
I'm trying to make a monthly summary sheet of inventory but don't know how
to fit multiple criteria within a statement.

I tried entering =sumproduct(--(monthrange=$C$1),--(typerange = $A2)) in the
cell next to part type a, but got a #NAME? error. How does this formula take
into account the different types (a,b,c) of parts and what am I doing wrong??

For one product my first column of data is the month # (1, 2, 3..), second
column is part type (type a, type b, type c, ...). On my summary worksheet
for this product I list the part types in consecutive rows and I'd like to
have a formula that links the
summary worksheet to my inventory sheet so that when I type in a specific
month I'm interested in, the number of type a, type b, and type c parts used
during that month will display.
Example Inventory sheet:
Month Type
1 a
1 a
1 b
2 a
3 a
3 c

Example Summary sheet:
Type specific month in cell C1: (e.g. 1)

#type a: 2
#type b: 1
#type c: 0

Please respond with example formulas.
Thanks in advance.