Div/0 error summarizing tables

[Taiter]

Greetings, First let me thank you in advance with any help and/or suggestions. I have 5 tables that I am summarizing on a new tab. I am using the following formula to get my totals for one column that has repeating values, and want just the total the unique data points, of
SUMPRODUCT(1/COUNTIF(TableA[Data1],TableA[Data1])).

If a table has not had data added yet I get a DIV/0! Error.
I tried changing it to
IF(TableA[Data1],SUMPRODUCT(1/COUNTIF(TableA[Data1],TableA[Data1]),0)) get a return of FALSE.

Is there a better (easier) formula that I could use to just show Zero for those tables that have not had data added to the list (yet)? Again, Thank you for any assistance.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

One option

=IFERROR(SUMPRODUCT(1/COUNTIF(TableA[Data1],TableA[Data1])),0)

 

[Taiter]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

One option

=IFERROR(SUMPRODUCT(1/COUNTIF(TableA[Data1],TableA[Data1])),0)

Thank You, that looks like it will work for me. I did update my account as you suggested

 

[Fluff]

I did update my account as you suggested

Thanks for that.
With 365 another option is

=IFERROR(ROWS(UNIQUE(FILTER(TableA[Data1],TableA[Data1]<>""))),0)