May 06 2022 10:05 AM
May 06 2022 10:05 AM
I am using the formula =(SUMPRODUCT(1/COUNTIF(Hello!A2:A9993,Hello!A2:A9993&"")))-1
but it returns the incorrect math (values +1)
If I change my formula to =(SUMPRODUCT(1/COUNTIF(Hello!A2:A9993,Hello!A2:A9993&"")))-2 it returns the correct value.
Any suggestions as to why this is happening with my formula?
May 06 2022 04:54 PM