Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
average formula
I have a project that collects data from multiple worksheets. On each
sheet one cell keeps a count of times a person is in the office. What I want to do is have one formula that will average each of these counts only if the count is greater than zero. I can get the average of all of them together but the total comes out inaccurate because of the number of sheets that haven't had information put into them yet. I've hit a pretty big road block and my deadline is looming...Any advice? |
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 | |||
Average Formula | Excel Worksheet Functions | |||
Average Formula | Excel Discussion (Misc queries) | |||
how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
#N/A In Max min Average Formula | Excel Worksheet Functions |