COUNT Formula with Filter

[onthegreen03]

Hi - I have a list of accounts (some repeating) and a corresponding list of zones. See the example below. In cells G12:G14 I want to add a formula that counts the number of unique accounts by zone. I tried the following formula (cell G12) but it is returning all zeroes. =COUNT(UNIQUE(FILTER('90 Day'!$C$6:$C$30,'90 Day'!$D$6:$D$30=$G12))). What am I doing wrong? Thanks!

 

[Fluff]

Use Rows instead of Count.

 

[onthegreen03]

Thanks Fluff. Of course it worked and thank you!

 

[Fluff]

You're welcome & thanks for the feedback.