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.)