Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average from three different coworkers excluding zeros formula?
I'm trying to average from three different cells only if greater than zero,
each from a different sheet within a workbook. This is the formula I use now, =AVERAGE(Denise!C318,Georgia!C318,Ora!C318) but I have to go in and delete the zeros each day, any ideas? Thanks for your time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average from three different coworkers excluding zeros formula?
One option:
Put this formula in cell A1: =Denise!C318 Put this formula in cell A2: =Georgia!C318 Put this formula in cell A3: =Ora!C318 Put this formula in cell A4: =SUM(A1:A3)/SUMPRODUCT(--(A1:A30)) That should give you the average leaving 0s out of the calculation. Any men in your database? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average from three different coworkers excluding zeros formula?
Actually, this formula in cell A4 is a little more direct.
=SUM(A1:A3)/COUNTIF(A1:A3,"0") Tom |
#4
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) |