| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DSUM or SUMPRODUCT?
OK I've tried this
data! being the second sheet holding the data the first array is a condition that I only want customers = "RETAILAC" to be included data!E = quantity data!W=cost price =SUMPRODUCT(data!DA2:DA7199="RETAILAC",data!E2:E71 99,data!W2:W7199) but this returns a 0 value any clues? thanks -- Vass |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
| Need help with sumproduct and dynamic ranges | Excel Worksheet Functions | |||
| sumproduct vs dsum | Excel Worksheet Functions | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Threaded Mode
