how do I get a cummulative total in excel

's Computer Specifications

I have a spreadsheet where I add daily totals. One of my columns is for a
percentage for the day. At the bottom of the page I need a month to date
average percentage. How can I do this. I have tried....(i.e. =AVERAGE
(L4:L34)). This is giving me an average of all 31 days of the month instead
of just the 5 that have accumulated.

Can you help me fix this?

's Computer Specifications

Excel ignores blank cells when averaging so if you have only 5 cells with
data, the average for L4:L34 will be only for those 5 cells.

Gord Dibben MS Excel MVP

On Wed, 6 Jan 2010 14:36:02 -0800, luvkoffee
<(E-Mail Removed)> wrote:

>I have a spreadsheet where I add daily totals. One of my columns is for a
>percentage for the day. At the bottom of the page I need a month to date
>average percentage. How can I do this. I have tried....(i.e. =AVERAGE
>(L4:L34)). This is giving me an average of all 31 days of the month instead
>of just the 5 that have accumulated.
>
>Can you help me fix this?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I calculate "cummulative percent of total" in a pivot table	=?Utf-8?B?U3RldmUgUA==?=	Microsoft Excel Misc	0	25th Sep 2007 02:06 PM
Cummulative total in Userform	=?Utf-8?B?THVpc0U=?=	Microsoft Excel Programming	4	29th Aug 2007 12:32 AM
a cummulative or to-date total based on time and metrics	dreamkeeper	Microsoft Excel Discussion	0	9th Aug 2006 06:16 AM
a cummulative or to-date total based on time and metrics	dreamkeeper	Microsoft Excel Discussion	0	9th Aug 2006 06:14 AM
Getting a cummulative total from a one-to-many	Ted Allen	Microsoft Access Queries	0	11th Mar 2004 04:04 PM