| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with this formula
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")*(WORKSH EET1!$J$3:$J$1000="MODEL#")*WORKSHEET1!$F$3:$F$100 0) |
Threaded Mode
