Ask Your Question

Revision history [back]

=SUMPRODUCT(Catalog.E4:E6000;"x";Catalog.G4:G6000;"x";OR(Catalog.M4:M6000="x";Catalog.M4:M6000="D";Catalog.M4:M6000="T"))

=SUMPRODUCT(Catalog.E4:E6000;"x";Catalog.G4:G6000;"x";OR(Catalog.M4:M6000="x";Catalog.M4:M6000="D";Catalog.M4:M6000="T"))=SUMPRODUCT(Catalog.E4:E6000="x";Catalog.G4:G6000="x";OR(Catalog.M4:M6000="x";Catalog.M4:M6000="D";Catalog.M4:M6000="T"))