AnsweredAssumed Answered

Help with a formula (Revised)

Question asked by fmpro_novice on Dec 1, 2014
Latest reply on Dec 2, 2014 by fmpro_novice


Help with a formula (Revised)


I'm trying to find the average of only the last 3 fields (that contain data) for the record showing in this diagram.

The fields are simply named One, Two, Three, Four, etc. I need the average to evaluate only the last 3 numbers entered. In the example shown, the first 6 numbers would be ignored and the average would only be based on the numbers 8, 5 and 6. Hence, the average of 6.3 showing in the gray box.

(The average is only showing correctly because I drew this in another program.)