Count of unique values not working.

[Herakles]

Hi

I hope that you are all safe and well.

I have the following formula which works well in Office 365 but someone gets a #DIV/0! error when using it in Version 2013. I don't have Version 2013.

=SUM(1/COUNTIF(OFFSET(Data!$B$1,MATCH(COLUMN()-1,tblTomsData[Week],0)-1,0,COUNTIF(tblTomsData[Week],COLUMN()-1),1),OFFSET(Data!$B$1,MATCH(COLUMN()-1,tblTomsData[Week],0)-1,0,COUNTIF(tblTomsData[Week],COLUMN()-1),1)))

Does it need to be an Array Formula in Version 2013?

It works as an Array Formula and not in Office 365.

Thanks

 

[sandy666]

maybe try array function SUMPRODUCT instead of SUM