max and sum

Hi, This is for Excel. I need a formula that returns the text when using a sum max for a number by date. In the below example, AA02 is the answer for January 2023 b/c 4,120 is the max sum (3,995 + 125). cell A1 1/31/2023 2/28/2023 Result AA02 CCC data set Month Year SKU total...

Hi, This is for Google Sheets. I need a formula that returns the text when using a sum max for a number by date. In the below example, AA02 is the answer for January 2023 b/c 4,120 is the max sum (3,995 + 125). cell A1 1/31/2023 2/28/2023 Result AA02 CCC data set Month Year...

Hi, I am trying to calculate the maximum sum of values within an hour in column. Because the number of values within an hour isn't constant (see my example below) I'm having a lot of trouble trying to get this to work. As you can see in the sheet below, the times are in column A and the value...

Hi I have a sheet where I am looking for a formula to add to C14,D14,E14,F14.G14 & H14 to calculate 15% of C13,D13,E13,F13,G13 & H13 up to a limit e.g. the maximum is 20,000 over a few months month. E.G if profit is sufficient in cells C14,D14 & E14 or any combination of columns where 15|% of...

In columns B and C we have the time and number of cars passing. The objective: find the max total of the sum of 7 consecutives numbers At present we have to split out the sum of 7 consecutive numbers (column G7-10) from data and then max those in G16. Is there a way to combine this to deliver...