Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula - average using a count
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
need to count/average if... | Excel Worksheet Functions | |||
how to average and use sum min and count within one cell | Excel Worksheet Functions | |||
how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Count and then average | Excel Worksheet Functions |