Formula to count Unique Values in one column based on 2 criteria from 2 other columns

[CAHIGHAM]

Hi,

I have dates in column E and routes in column AU. On another sheet I am trying to figure out the number of unique postal codes (column AH) delivered to by route and by date.

I feel like I need a sum product combined with a countifs. Can't figure it out.

Thanks for any help you can provide.

 

[CAHIGHAM]

ROUTE	DATE	POSTAL
NVP01	5/23/2018	V7X1K8
NVP01	5/23/2018	V6E4S3
NVP01	5/23/2018	V6E4A2
NVP01	5/23/2018	V6E4A2
NVP01	5/23/2018	V6E0C5
NVP01	5/23/2018	V6E0C5
NVP01	5/23/2018	V6Z2S9
NVP01	5/23/2018	V6Z2S9
NVP01	5/23/2018	V6E2J3
NVP01	5/23/2018	V6E0C5

<colgroup><col width="68" style="width:51pt" span="3"> </colgroup><tbody>
</tbody>

Here is a sample. The value I am trying to get is route NVP01 had 7 stops (7 unique postal codes) on May 23rd.

I need the formula to search data to find the route, the date, and then count unique postal code values.

 

[AhoyNC]

Maybe something like this:
Change ranges to match your data.
This is an array formula and must be entered with CTRL-SHIFT-ENTER.
Drag formula down as needed

Excel Workbook
	E	F	G	H	I	J	K
1	Dates	Routes	Postal Code		Find
2	6/1/2018	1	30027		Date	Route	Unique
3	6/1/2018	1	30026		6/1/2018	1	2
4	6/1/2018	1	30027		6/1/2018	2	2
5	6/1/2018	2	30027		6/1/2018	3	1
6	6/1/2018	2	30028		6/5/2018	1	3
7	6/1/2018	1	30027		6/5/2018	2	1
8	6/1/2018	1	30026		6/5/2018	3	1
9	6/1/2018	3	30030
10	6/1/2018	3	30030
11	6/5/2018	1	30030
12	6/5/2018	1	30026
13	6/5/2018	1	30026
14	6/5/2018	1	30030
15	6/5/2018	1	30031
16	6/5/2018	2	30038
17	6/5/2018	2	30038
18	6/5/2018	3	30025
Sheet

 

[CAHIGHAM]

This worked! Thanks very much for your help.

 

[AhoyNC]

You're welcome. Thanks for the feedback.