For some reason I only get DIV/0 Error when I apply this SUMPRODUCT+COUNTIF

[RockandGrohl]

https://trumpexcel.com/count-unique-values-in-excel-countif/

On this page explains the formula, he states that if you get DIV/0 errors it's because there is a blank value somewhere in the formula which counts it as a "0", which it cannot divide.

The formula is as follows:

=SUMPRODUCT((1/COUNTIF(NAMES,NAMES&””)))


This formula should not be considering blank values and thus it shouldn't matter. For the record, in my spreadsheet it looks more like this:

=SUMPRODUCT((ISTEXT(P3)/COUNTIF(P3:P$195851,P3&””)))

I'm not using named ranges and my SS is nearly 190,000 rows long (it's a biggun!)


Can anyone help? Thanks.

 

[steve the fish]

Id imagine its your P3&"". Its likely you copied this formula from a website. The "" need to be straight not slanting.

 

[RockandGrohl]

Id imagine its your P3&"". Its likely you copied this formula from a website. The "" need to be straight not slanting.

Steve the Fish, more like Steve the Genius.

Thank you!