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
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