count

[realpixel]

Hello,

I have the following board

HMCONT	CUSTO	TRANS	DATE MOV	DATE ENTREE	PEV
U6451156	CUSTO1	SV	19/03/2013	10/01/2013	2
U6451156	CUSTO1	SV	19/03/2013	19/03/2013	2
U2520054	CUSTO1	SV	18/03/2013	10/01/2013	1
U2520054	CUSTO1	SV	19/03/2013	19/03/2013	1
U7000870	CUSTO1	SV	19/03/2013	10/01/2013	2
U7000870	CUSTO1	SV	19/03/2013	19/03/2013	2

I use the function =count(distinct HMCONT) to do a sum of count column [PEV], for this example the total of [PEV] return = 3

But I need to count PEV 2 = 2 and 1 = 1 always for this example the result must be = 5

Someone have an idea how to do this operation?