Hello everybody ,
I find myself confronted to a wierd problem ;
I wish to count in a list all the unique values that meet four different
criterias .
So far I managed to workout the folowing formula :
{Sum(if($C$53:C$4983>=$F$4)*($C$53:$C$4983<=$J$4)*($I$53:$I$4983=$D$4)*($B$53:$B$4983=E5);1/countif(F53:F4983;F53:F4983))}
but it doesn't work
Any ideas
thanks
david
I find myself confronted to a wierd problem ;
I wish to count in a list all the unique values that meet four different
criterias .
So far I managed to workout the folowing formula :
{Sum(if($C$53:C$4983>=$F$4)*($C$53:$C$4983<=$J$4)*($I$53:$I$4983=$D$4)*($B$53:$B$4983=E5);1/countif(F53:F4983;F53:F4983))}
but it doesn't work
Any ideas
thanks
david