Excel: Filtering values and generating an average result

Hi

I am using a formula that will compare one value to the previous value in a column and ignore them until the percentage difference between them reaches a certain value, example
=IF(D17 <=$G$1,C17,0) G1 being the reference percentage

The resulting values I want to add together and average them and only stop when the values drop below a percentage of the highest value. I cannot seem to get this part to work properly.

Have uploaded a workbook as an example.

I am new to Excel.

Many thanks
Phil

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

The count of cells in E24:E69 is 46, not 45, so formula in J8 should be:

=SUM(E24:E69)/46 yielding 2889 as does this using your G8 variable:

Please Login or Register  to view this content.

Sorry, i was playing around, testing, I forgot to change the hard coded 3013 with MAX($C$9:$C$84)

Please Login or Register  to view this content.