S
STEVE A
I'm using sumproduct to sort and count a database that meets certain
criteria. It was doing a great job until I needed to count a column with
variable criteria that I want to count.
=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"))
It would be easier if I could just say not count (ED,13,504,VA) and count
everything else that wasn't blank. Any suggestions?
criteria. It was doing a great job until I needed to count a column with
variable criteria that I want to count.
=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"))
It would be easier if I could just say not count (ED,13,504,VA) and count
everything else that wasn't blank. Any suggestions?