Hi Stephen,

You can use the

Code:

MAX

function in combination with the

Code:

SUM

function to find the highest total of any three consecutive numbers in a range. Here are the steps:

1. Select the range of cells that contains your numbers.
2. In an empty cell, enter the following formula:
   Code:

   =MAX(SUM(A1:A3),SUM(A2:A4),SUM(A3:A5),...)

3. Replace "A1:A3", "A2:A4", "A3:A5", etc. with the appropriate cell ranges for your data. For example, if your data is in cells A1 through A10, the formula would be:
   Code:

   =MAX(SUM(A1:A3),SUM(A2:A4),SUM(A3:A5),SUM(A4:A6),SUM(A5:A7),SUM(A6:A8),SUM(A7:A9),SUM(A8:A10))

4. Press Enter to calculate the formula. The result will be the highest total of any three consecutive numbers in the range.

This formula works by creating a series of

Code:

SUM

functions that each add up three consecutive numbers in the range. The

Code:

MAX

function then finds the highest value among those sums.