Adding Criteria

[Joe Galvan]

Hello All,

I have this formula which counts unique items... I need to be able to add multiple criteria to this formula.

=SUMPRODUCT(1/COUNTIF(A2:A10,A2:A10))

Customer

Vertex42

Hybrid Software

WM Squared Inc.

WSLCB

Excelerator BI

Excelerator BI

California Blazing Chile

Berghaus Corporation

Fintega Financial the Answer would be 8 thanks in advance! JOE

<tbody>
</tbody><colgroup><col></colgroup>

 

[FDibbins]

I need to be able to add multiple criteria to this formula.

What criteria would that be?

 

[Joe Galvan]

The criteria would be the Product and Date

~

Product	Date	Customer
Gizmo	1/4/2018	Vertex42
Gadget	1/4/2018	Hybrid Software
Gizmo	1/4/2018	WM Squared Inc.
Gadget	1/4/2018	WSLCB
Widget	1/7/2018	Excelerator BI
Gadget	1/7/2018	Excelerator BI
Widget	1/7/2018	California Blazing Chile
Gizmo	1/7/2018	Berghaus Corporation
Widget	1/7/2018	Fintega Financial

<tbody>
</tbody><colgroup><col><col><col></colgroup>