Unique Value with multiple criteria form other columns

[nooracam]

Hi All,

This is my first post here. I will do my best to explain my problem. Usually I don't have issues figuring out what I need form others' posts, but I'm really stuck here. I've been trying to figure this out for two full working days now and haven't solved it.

I am using a data dump file that feeds formulas on a topline sheet for a report. The data dump could have >40000 rows, and the number of rows may differ month to month. No blanks in the table, and all values are numeric. I'm using excel 2010.

Small sample of data:

A....B....C
1....7....1
1....2....0
1....9....1
4....9....0
4....9....1
4....7....1
12...9....0
12...66...0
12...66...0

Column A is customer number, column B is brands, and column C is a sales indicator. (1 means case sales>0, 0 means customer has not purchased that brand)

I'd like to count all the customers when column b = 7,9, or 66 and column c>0. The above data would return '2.'

Below is a formula I put together based on my readings of other threads, but it's returning the wrong number for some reason, and I can't wrap my head around it.

=SUM(IF(FREQUENCY(IF(OR('key acct'!A:A<>"",'key acct'!B:B=7,'key acct'!B:B=9,'key acct'!B:B=66),IF('key acct'!C:C>0,'key acct'!A:A)),'key acct'!A:A)>0,1))

Thanks in advance for the help.

Cheers!

 

[Big Bruiser]

Perfect, thank you!

 

[T. Valko]

Perfect, thank you!

You're welcome. Thanks for the feedback!