| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average from three different coworkers excluding zeros formula
Thank you for working on my problem, but I need an average formula that will
go into one cell. Each coworkers sheet has data in each column, one row for each day of the year. The last sheet is a summary page of everyone's numbers from that day. If I copy the links to other cells in order to sum count a range, I would have to do it for each day of the year. An average formula would go into one cell that would average for each day's numbers. Thanks again. "TomPl" wrote: Actually, this formula in cell A4 is a little more direct. =SUM(A1:A3)/COUNTIF(A1:A3,"0") Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average percentage excluding zeros from several worksheets | Excel Discussion (Misc queries) | |||
| Count if, excluding zeros | Excel Discussion (Misc queries) | |||
| Average percentage excluding zeros spanning numerous tabs | Excel Discussion (Misc queries) | |||
| Average, Excluding Zeros, Non-Consecutive Range | Excel Discussion (Misc queries) | |||
| EXcluding Zeros from the average in a row | Excel Discussion (Misc queries) | |||
![Rhett C[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
