Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Formula
How can I write the average formula so it does not count the cells with zeros
in it... A1= 12 A2= 0 A3 = 12 A4 = 0 A5= 12 A6 =0 if I write the formula as =average(a1:a6) the value is 6, but I want it to read 12. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Formula
{=AVERAGE(IF(A1:A6<0,A1:A6))}
*** This is an array formula, and is to be confirmed with CTRL+SHIFT+ENTER rather than with simply ENTER. The curly brackets {} are not to be typed manually, those are entered by the Excel, when the formula is entered as an Array formula. *** Micky "Peter" wrote: How can I write the average formula so it does not count the cells with zeros in it... A1= 12 A2= 0 A3 = 12 A4 = 0 A5= 12 A6 =0 if I write the formula as =average(a1:a6) the value is 6, but I want it to read 12. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average formula | Excel Discussion (Misc queries) | |||
AVERAGE Formula Help | Excel Discussion (Misc queries) | |||
A formula to AVERAGE IF but only average a set number of values | 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 |