Hello,

I don't know if this can be done, but here goes. I have a formula; =SUMPRODUCT((E2:E2500)*(C2:C2500="Bath Blanket")*(INT(A2:A2500)=DATE(2012,11,15))). I would like to ask the user for values to input into the formula shown above.

For instance; =SUMPRODUCT((E2:E2500)*(C2:C2500="User input")*(INT(A2:A2500)=DATE([COLOR="#0000CD"]User inputs this date in this format 2012,11,15)))

Is there someway to allow the user to input values into formulas via inputboxs? I.E. C2:C2500 = " User input value" and the same holds true for the date in the original formula INT(A2:A2500="User inputs date in same format ")

What I am trying to do is extrapolate out a value out of using two different criteria to reference that value if that makes sense, so ......
in the attached workbook I would like to be able to input two values; "Pillowcases" for the data of "10/1/2012" and then get a total count of 175 pillowcases for the date of 10/1/2012.

I could probably use a pivot sheet, but am not at all comfortable with them. I would rather not change the worksheet in anyway if I can get away with it.

So the macro would do: What's the Item Description? Answer "Pillowcases" Secondly; What's the Date? "2012, 10, 1" and the Answer is 175.

Thanks for any suggestions or direction with this,

LeapingLizardBook1.zip