Forum Discussion
Help: Formula to count no repeat values between dates
Hi! I would like to know a formula to count no repeat values between dates. I mean if we got a column with values and another one with dates (find an example attached) I would like to know how many o...
Abiola1 Thanks!
That is the formula that I wanted
{=SUMA(SI((B2:B9>=E1)*(B2:B9<=E2);SI(CONTAR.SI.CONJUNTO(B2:B9;">="&E1;B2:B9;"<="&E2;A2:A9;A2:A9)=1;1;0);0))}
Alright..
Regards
Regards