Need help with this formula

J

Joseph

A little background...The data is in Worksheet1 and I want to show the
results in Worksheet2. Column A=Month, Column B=Date mm/dd/yyyy format. I
want to get rid of column A and just use the Date format above....Help??


SUMPRODUCT((WORKSHEET1!$A$3:$A$1000="JAN")*(WORKSHEET1!$J$3:$J$1000="MODEL#")*WORKSHEET1!$F$3:$F$1000)
 
D

Don Guillett

try
SUMPRODUCT((month(WORKSHEET1!$b$3:$b$1000)=1)*(WORKSHEET1!$J$3:$J$1000="MODEL#")*WORKSHEET1!$F$3:$F$1000)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can anyone help me with this formula? 1
Need help with formula 3
Formula questions 3
DBSUM function but with function as criterion, not a range 3
Reference to another worksheet cell in a sumproduct formula 1
Finding min date value with hidden zeros with vlookup 4
sorting through unknown source data as it is entered 1
VBA - exporting serial letters to single documents 0

Top