Summing Unique Entries
I have two columns of over 400 entries in the general format below
NJ/64522/60377 14.5
NJ/64662/60060 7.64
NJ/64907/60388 19.98
NJ/64907/60388 19.98
NJ/61556/59022 2.79
NJ/61641/58422 10.76
NJ/61751/58457 8.03
NJ/61856/58771 11.41
NJ/61856/58771 11.41
NJ/61900/57968 14.93
NJ/61914/59108 19.68
NJ/62038/58548 14.36
NJ/62048/58278 1.38
NJ/62086/58070 2.95
NJ/62158/59052 2.55
NJ/62211/58854 1.17
There are duplicate entries in column A which have the same values in
column B. What I want to do is get the total of all these entries for
only the unique values which would be 132.13 in this case. I know I can
do a unique advanced filter on them and then use the Subtotal function
to give me the figure I am after. Hovwever for what I am doing it would
be really useful if this exercise could be condensed into one function
in a cell. I would value any guidance
Kind Regards
Graham
Turriff
Scotland
|