ExcelBanter - SUMPRODUCT HELP

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMPRODUCT HELP (https://www.excelbanter.com/excel-worksheet-functions/246180-sumproduct-help.html)

=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

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