need some basic help

  • Thread starter Thread starter Matthew
  • Start date Start date
M

Matthew

I have a basic daily sales sheet that has a number value in column one for
the day of the month from 1 to 31, column 2 has the daily sales that I put
in manually and column 3 has the total sales for the month =SUM(B2+C1). At
the bottom on row 31 I calculate daily average sales with a basic =C3/C1
and I have to change on a daily basis by hand... all extremely basic stuff.
But I'm looking for a way to calculate the daily average sales automatically
as I put in the daily sales each day without having to edit the row 31
formula every day. I tried googling for daily average sales but that kept
giving me moving averages which didn't seem the right direction.
 
Matthew presented the following explanation :
I have a basic daily sales sheet that has a number value in column one for
the day of the month from 1 to 31, column 2 has the daily sales that I put in
manually and column 3 has the total sales for the month =SUM(B2+C1). At the
bottom on row 31 I calculate daily average sales with a basic =C3/C1 and I
have to change on a daily basis by hand... all extremely basic stuff. But I'm
looking for a way to calculate the daily average sales automatically as I put
in the daily sales each day without having to edit the row 31 formula every
day. I tried googling for daily average sales but that kept giving me moving
averages which didn't seem the right direction.
Click to expand...

Did you try using the AVG() function at the bottom of ColB?
 
GS said:
Matthew presented the following explanation :

Did you try using the AVG() function at the bottom of ColB?
Click to expand...


Ahh.. I am an idiot. I tried the average formula but I selected the wrong
data. Sorry to bother.. thanks for the help
 
Matthew used his keyboard to write :
Ahh.. I am an idiot. I tried the average formula but I selected the wrong
data. Sorry to bother.. thanks for the help
Click to expand...

We all have those days<g>! You're welcome...
 
I have a basic daily sales sheet that has a number value in column one for
the day of the month from 1 to 31, column 2 has the daily sales that I put
in manually and column 3 has the total sales for the month =SUM(B2+C1). At
the bottom on row 31 I calculate daily average sales with a basic =C3/C1
and I have to change on a daily basis by hand... all extremely basic stuff.
But I'm looking for a way to calculate the daily average sales automatically
as I put in the daily sales each day without having to edit the row 31
formula every day. I tried googling for daily average sales but that kept
giving me moving averages which didn't seem the right direction.
Click to expand...

What's wrong with =AVERAGE()?

You can have =AVERAGE(B1:B31) in a cell like say B32 or B33. The
AVERAGE function ignores blank cells.
 
Back
Top