Excel - AVERAGEIF - only when cell value is greater than 0

[harriet60]

I have a sheet that pulls through average times for trial dates.
When using the AVERAGE function, it correctly returns an average of all selected cell values but on some days I have a value of 0 because the trial did not run.
At present I am having to manually change the formula daily which is time consuming.
Does anyone know how to get an average by using only values above zero, regardless of the cells selected?
If you can help I will be very grateful - thanks

 

[Fluff]

How about

=AVERAGEIFS(F13:F30,F13:F30,">0",E13:E30,"sub1")

 

[harriet60]

How about

=AVERAGEIFS(F13:F30,F13:F30,">0",E13:E30,"sub1")

This works perfectly - thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.