Hi All

Im having trouble making a formula that averages a sum by the number of cells that contain data
I.e
I have 12 cells, on a row. (A1 to A12). In A13 i have a total of A1 to A12
In A13 i need to average the total by the number of cells in A1-A12 that contain data
i know i can have a cell that does the count, and then another cell that divides the total by the cell count, but that make this messy on the spreadsheet. (Used for financial reporting.

Im not sure on an appropriate formula.
Could someone possibly tell me a formula/function that i can use for the above

Thanks heaps

Toby.