SUMPRODUCT HELP

  • Thread starter Thread starter STEVE A
  • Start date Start date
S

STEVE A

=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
 
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
 
Back
Top