Re: Averages
- From: tony h <tony.h.29jevb_1150532402.604@xxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 17 Jun 2006 03:15:33 -0500
try
=SUM(A31:A99)/COUNTA(A31:A99)
This formula is using data in column A and allows you to fill in values
between rows 31 and 99 without needing to change theformula
hope this helps
--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21074
View this thread: http://www.excelforum.com/showthread.php?threadid=552892
.
- Follow-Ups:
- Re: Averages
- From: Zygy
- Re: Averages
- References:
- Averages
- From: Zygy
- Averages
- Prev by Date: Averages
- Next by Date: Getting a cell address from Vlookup function in a macro?
- Previous by thread: Averages
- Next by thread: Re: Averages
- Index(es):
Relevant Pages
|
Loading
