Try this:

=SUM(IF(FREQUENCY(IF((prN={"PIERRE","LUC"})*(vaL< ""),MATCH(dtS,dtS,0)),MATCH(dtS,dtS,0))0,1))

ctrl+shift+enter, not just enter


"Sabine" wrote:

Hi,

Forgiveness in advance for my English ...

In column A, dates (dtS), in B names (prN) and C numerical values (vaL),
like example below:
01/01/2008 PIERRE 3
01/01/2008 LUC 4
01/01/2008 PAUL
02/01/2008 PAUL 7
02/01/2008 PIERRE
03/01/2008 PAUL 8
03/01/2008 PIERRE
05/01/2008 LUC 8
05/01/2008 PIERRE 1

I would like a formula in a single cell (matrix) which I counted the number
of lines having the same date in column A on the same line
names research "Pierre or Luc" in column B and numerical value in column C.
In my example, the formula would result in 2 because on line 1 and 2, 8 and
9, we find the same date for Pierre or Luc in column A, Pierre or Luc in
column B, and a numerical value in front in column C of Pierre and Luc.

For conditional formatting, it would be something like:
=(NB.SI(dtS;$A2)1)*(($B2="pierre")+($B2="luc"))*( $C2<"")

I tried this, but that does not give the expected results:
{=SOMME((NB.SI(dtS;dtS)1)*((prN="pierre")+(prN="l uc"))*(vaL<""))}
;-(

Thanks in advance for your help,


Sabine