P
Paulo
This question was posted before but the solution proposed used different
functions. I would like to insist. Is there a modification to the formula
below, using SUMPRODUCT, that allows to retrieve the number of unique itens
that meet a 2nd criteria?
Original formula:
=SUMPRODUCT((A1:A20<>"")/COUNTIF(A1:A20,A1:A20&""))
In my case, I need the numbers of unique branches (column B) that meet a
specifc criteria in another column (M). So, I have the formula:
=SUMPRODUCT((all!$B$2:$B$5514<>"")/COUNTIF(all!$B$2:$B$5514,all!$B$2:$B$5514&""))
but I need to include the 2nd criteria:
(all!$M$2:$M$5514=$A22)
Thanks in advance,
Paulo
functions. I would like to insist. Is there a modification to the formula
below, using SUMPRODUCT, that allows to retrieve the number of unique itens
that meet a 2nd criteria?
Original formula:
=SUMPRODUCT((A1:A20<>"")/COUNTIF(A1:A20,A1:A20&""))
In my case, I need the numbers of unique branches (column B) that meet a
specifc criteria in another column (M). So, I have the formula:
=SUMPRODUCT((all!$B$2:$B$5514<>"")/COUNTIF(all!$B$2:$B$5514,all!$B$2:$B$5514&""))
but I need to include the 2nd criteria:
(all!$M$2:$M$5514=$A22)
Thanks in advance,
Paulo