| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
running avg formula that ignores blanks
I am attempting to build a formula that averages a column of data (that gets
added to every day), but ignores, or does not include blank rows. Any hints? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
running avg formula that ignores blanks
One way:
=AVERAGE(A:A) In article , "Happy" wrote: I am attempting to build a formula that averages a column of data (that gets added to every day), but ignores, or does not include blank rows. Any hints? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
running avg formula that ignores blanks
I'm not sure I understand this........ possible to give an example?
"JE McGimpsey" wrote in message ... One way: =AVERAGE(A:A) In article , "Happy" wrote: I am attempting to build a formula that averages a column of data (that gets added to every day), but ignores, or does not include blank rows. Any hints? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
running avg formula that ignores blanks
Put your numbers in column A.
Empty some cells. Put that formula in B1. You'll see that =average() ignores text and empty cells. Happy wrote: I'm not sure I understand this........ possible to give an example? "JE McGimpsey" wrote in message ... One way: =AVERAGE(A:A) In article , "Happy" wrote: I am attempting to build a formula that averages a column of data (that gets added to every day), but ignores, or does not include blank rows. Any hints? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula/macro that ignores cells nonblanks | Excel Discussion (Misc queries) | |||
| Autofilter SORT that Ignores Forced Blanks ("") | Excel Worksheet Functions | |||
| formula ignores last infor - please help | Excel Worksheet Functions | |||
| How do you use text in a formula so it will calc, but ignores txt | Excel Discussion (Misc queries) | |||
| How do i get an average that ignores blanks in the range of cells. | Excel Worksheet Functions | |||
Linear Mode
