albertc30
Well-known Member
- Joined
- May 7, 2012
- Messages
- 1,091
- Office Version
- 2019
- Platform
- Windows
Hi all.
After about 30 minutes googling away I have given up.
I am trying to count unique values which usually is quite straight forward but now I am getting #DIV/0! error.
I am using the formula "=SUMPRODUCT(1/COUNTIF(D5:D250,D5:D250))" and have used others to no sucess.
Column D has a dropdown list with validation. Could this be why it's not working?
As always, many thanks for all the help and be safe.
Albert
After about 30 minutes googling away I have given up.
I am trying to count unique values which usually is quite straight forward but now I am getting #DIV/0! error.
I am using the formula "=SUMPRODUCT(1/COUNTIF(D5:D250,D5:D250))" and have used others to no sucess.
Column D has a dropdown list with validation. Could this be why it's not working?
As always, many thanks for all the help and be safe.
Albert