Average Formula

[Guest]

Hi,
can anybody advise of a formula to work out an average on a given number on
the days passed in the month.....??
eg
data below for first 5 days of month
day1,20
day2,25
day3,32
day4,10
day5,9
so the average thus far in the month will be 19.2 (first 5days data divided
by 5)

if days 6 and 7 are added the formula would then work out the average for
the first 7 days.....and so on
hope thats clear
thanks

 

[Lewis Clark]

I would recommend putting the "day1" and the "20" in separate columns. Then
use the Average function to find your average - it will only include cells
with numbers in them. Set the range for the average function to the number
of rows you need for the month (31 rows will cover all possible months).

 

[Bob Phillips]

Assuming the values in B1:B31

=AVERAGE(IF(B1:B31<>0,B1:B31))

which is an array formula, so commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Nice one Bob - thanks

Assuming the values in B1:B31

=AVERAGE(IF(B1:B31<>0,B1:B31))

which is an array formula, so commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)