Hi, I'm hoping someone could help with finding a formula. I'd like to find the average in column A from when column B is > 0 to when column A is reducing in value and reaches the value of column C + 30 (44.09). This would be the average in column A row 5 to row 14, giving a result of 46.47. The attached Excel has everything set up with header and column values are setup in Name Manager

Attachment 798382

A B C
1 Temperature3 SecondatFlowRate Ct
2 38.60 0.00 14.09
3 38.68 0.00 14.09
4 38.68 0.00 14.09
5 39.15 16.43 14.09
6 42.12 16.91 14.09
7 45.60 14.05 14.09
8 49.08 15.98 14.09
9 52.56 15.80 14.09
10 53.47 14.97 14.09
11 50.36 15.03 14.09
12 47.25 14.97 14.09
13 44.13 15.03 14.09
14 41.02 15.00 14.09
15 37.91 15.00 14.09
16 34.82 14.97 14.09

Many thanks,
Will