Count unique combination of values in multiple columns

[2077delta]

I have a table where the the cells in column A are color coded and there are values in columns B:E with no color. I have a unique list of the items in column A at the bottom of my list with the cells color coded. I need a function that I can look at the cell color in my unique list at the bottom of the table and count how many items in the column above (columns B:E) have values greater than zero.

 

[StephenCrump]

B10: =COUNTIFS($A$2:$A$7,$A10,B$2:B$7,">0")
F10: =SUMPRODUCT((B$2:E$7>0)*(A$2:A$7=A10))

Book1
	A	B	C	D	E	F
1	ID	Field1	Field2	Field3	Field4
2	x	30	19	-4	-5
3	y	6	18	-9	27
4	z	10	27	4	-8
5	x	20	29	23	-10
6	y	24	27	27	21
7	x	-6	29	26	9
8
9	Uniques	Field1	Field2	Field3	Field4	Total
10	x	2	3	2	1	8
11	y	2	2	1	2	7
12	z	1	1	1	0	3
Sheet1

You'll have to explain in more detail how cell colour comes into the equation? Also, is the cell colour formatting? Or conditional formatting?

Depending on what you need, you may need a VBA solution. Is that OK?