Count number of cells containting different data

[blacktour]

I have this data:

PRODUCT #                           STREET             CLASS      TOTAL
111701086000000             Sparks Street             CF           3
111701086000000             Sparks Street             DF           7
111701086000000 Total                                           10
				
800701191000000                Lorne Bldg              CF	     11.3
800701191000000                Lorne Bldg              CF	     3.4
800701191000000 Total                                              14.7
				
450701228000000             Marshall Bldg              CF        1.53
450701228000000 Total                                          1.53

I want a function to count how many different classes there are for each product. Maybe sumproduct or vlookup can handle this not sure I can't make it work. Any ideas?

Thanks,
Mike

 

[Paddy1979]

Hi, The below formula will count unique records within the range A1:A5

=SUMPRODUCT((A1:A5<>"")/COUNTIF(A1:A5,A1:A5&""))

Regards
Paddy