Re: Count unique values from different columns with a condition

Hi,
I need some help to find a formula (Excel 2003 otherwise Excel 2010).
I have this table:

	A	B	C	D	E
1	model	type	color1	color2	color3
2	aaa	metallized	gray	red	blue
3	bbb	MATT	white	black
4	ccc	metallized	gray	green
5	ddd	MATT	white	black	red

I need to count unique value of range C2:F5 with condition in B:B "METAL"
Example:
METAL = 4 (gray, red, blue, green)
matte = 3 (white, black, red)

... if it's possible also the subtotale if apply a filter in column A.

Thank for the help.