I am trying to sum unique values among duplicates horizontally. I cannot use
the frequency formula as this only works if the values are listed vertically.
The version of excel I am using is Microsoft Excel 2003.