maximum sum

  1. R

    How to count the amount of times a value is maximum

    Hi, I'm struggling to find the correct formula - I want to count the amount of times someone has got the highest value in a class. I've provided a photo to show what I mean, I want to have a formula that counts who scored the top mark in the class in each week. Its a bit hard to articulate but...
  2. R

    How to determine maximum sum of multiple ranges?

    Hey all: For a large column of data, I would like to determine the maximum sum of sequential 24-row ranges. To do this, I would essentially need to sum every 24 rows of data, and then determine the maximum value of the resulting sums. The problem is, there are almost 9000 rows of data to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top