Avg amount per day - Excel XP/2002

[TAJ Simmons]

Data:

A B
01-Nov-03 10
01-Nov-03 10
01-Nov-03 10
02-Nov-03 20
03-Nov-03 10
03-Nov-03 30

I'm trying to workout an *overall average per day.*

01-Nov-03 total = 30
02-Nov-03 total = 20
03-Nov-03 total = 40

So the overall average per day = 30

I've messed around with countif and mode and avg and got no where

Any suggestions? (clean ones)

Cheers
TAJ Simmons
microsoft powerpoint mvp

awesome - powerpoint backgrounds,
free sample templates, tutorials, hints and tips etc
http://www.powerpointbackgrounds.com

 

[CLR]

How about =SUMIF(dadadada)/COUNTIF(dadadada)

Vaya con Dios
Chuck, CABGx3

 

[Debra Dalgleish]

If you don't need the information in the adjacent column, you can create
a pivot table to summarize the data. There are instructions and links here:

http://www.geocities.com/jonpeltier/Excel/Pivots/pivottables.htm

For your example, add Date to the Rows area, and Qty the Data area.

 

[Randall Roberts]

with all your date in column a and all your data in column be you can
use the following formula

entered in to cell C1



=SUM(B:B)/SUM(N(FREQUENCY(A:A,A:A)>0))