Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT HELP
=SUMPRODUCT((SORTFLE1!$B$2:$B$1000="Auto
Body")*(SORTFLE1!$D$2:$D$1000="Dodd")*(SORTFLE1!$G $2:$G$1000<"ED,13,504,VA")*(SORTFLE1!$H$2:$H$1000 ="AM")) I'm counting to number to multiple specific criteria in a database. It was working fine until I tried to add SORTFLE1!$G$2:$G$1000<"ED,13,504,VA" I thought it would be easier to just say count the number of occurances that meet all criteria that doesn't equal these codes. Is it possible -- STEVE A |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT HELP
As responsed in your earlier thread:
Try replacing this term in your sumproduct expression: (SORTFLE1!$G$2:$G$1000<"ED,13,504,VA") with this: (ISERROR(MATCH(SORTFLE1!$G$2:$G$1000,SORTFLE1!$E$3 :$E$6,0)))*(SORTFLE1!$G$2:$G$1000<"") Success? Celebrate it, hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "STEVE A" wrote: =SUMPRODUCT((SORTFLE1!$B$2:$B$1000="Auto Body")*(SORTFLE1!$D$2:$D$1000="Dodd")*(SORTFLE1!$G $2:$G$1000<"ED,13,504,VA")*(SORTFLE1!$H$2:$H$1000 ="AM")) I'm counting to number to multiple specific criteria in a database. It was working fine until I tried to add SORTFLE1!$G$2:$G$1000<"ED,13,504,VA" I thought it would be easier to just say count the number of occurances that meet all criteria that doesn't equal these codes. Is it possible -- STEVE A |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions |