2 Replies Latest reply on Sep 21, 2015 8:57 AM by Jonathan Drummey

    How do I calculate a Column sum after selecting maximum values for Row totals?

    Peter Vint

      I am sure this is somehow simpler than I am making it out to be, but here’s my problem. I am trying to calculate the sum of a series of maximum values. In the attached, see the Best Olympic Finish worksheet. Here, I am finding the best Olympic finish for Winter Sports over the past three Olympic Games. I was able to do this by selecting “Maximum” from Analysis > Total > Total All Using > Maximum. However, now I want to calculate a sum of the “Best” (maximum) column (and actually, I'd like the sum of all columns as well).  How do I do this?