sumproduct and vlookup?

[deshpande.adi]

hi ..

i am trying to create a database for some products, i am working with
multiple sheets now the problem i am facing is this ... i want to sum
up the quantities of a product of a particular month and diplay it..
for eg: 'sheet 1'

Partno Quantity Date
121 400 7/20/06
121 500 7/21/06
122 300 7/22/06
122 400 8/23/06

now the second sheet 'sheet 2' will be like this

Partno Month Total Qunatity
121 July 900
122 July 300
122 Aug 400

the partno and the month will be given by the user, i tried using SUMIF
with VLOOKUP and also SUMPRODUCT but am not able to resolve this ...
can someone please help me...

adi

 

[Don Guillett]

=sumproduct((month(c2:c22)=7)*(a2:a22=121)*b2:b22)

 

[deshpande.adi]

but that would work if i know that the part no is going to be 121or 122
but the user will decide from a list of about 100 odd parts which one
he wants and both these datas are on different sheets

adi

 

[Don Guillett]

Then use indirect to reference the drop down list. Or, seek professional
help.