| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT, two criteria (date and product type)
Hello,
I really need some help with the SUMPRODUCT function. I've never used it before but i think i could really help me in this situation. Column A has Product Types (i.e. 1004,1005,1006,1013,...) and column I has Dates. I want to have to different SUMPRODUCTs. (1) count all product types based on Product type in cell A6 and the Date in cell A2 located on another worksheet. (2) The same as sumproduct (1) but do it based on Product type in cell A6 and between a specified date range imputted as two dates in cell A3 and A4 on another worksheet. Is this possible? Thanks and happy holidays, Bryce |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| product date stamp file save | Excel Discussion (Misc queries) | |||
| Need Help with a Date Sum Product | Excel Worksheet Functions | |||
| How do I retrieve a date in a column of dates which > my criteria | Excel Worksheet Functions | |||
| Sumproduct with Date column | Excel Worksheet Functions | |||
| A coupon organizer with product name, value, exp. date, etc. | Excel Discussion (Misc queries) | |||
Threaded Mode
