Excel Formulas
 

I want to create a formula in cell B13 that will add up cells B1 thru B12 and
give me an average in B13. However, B1 thru B12 represent each month and I
want a running monthly average figured in B13 as I enter each month. So... I
want to enter January Figure in B1, February Figure in B2 and have the
Average in B13. Then I want to add March Figure in B3 and have the average
of the first three in B13 and so on and so on so I can compare Monthly
Averages this year with a total monthly average from Last year in column B14.
I have no idea how to do this. Any help is appreciated!

Thanks to all,
--
Sam

Excel Formulas
 

Put this in B13:

=AVERAGE(B1:B12)

It will ignore blank cells, so as you add numbers into B1:B12 it will
give you their average.

If all the cells are empty it will return the #DIV/0 error, but you
can avoid that with this:

=IF(COUNT(B1:B12)=0,"",AVERAGE(B1:B12))

Hope this helps.

Pete

On Jan 21, 5:16*pm, Sam wrote:
I want to create a formula in cell B13 that will add up cells B1 thru B12 and
give me an average in B13. *However, B1 thru B12 represent each month and I
want a running monthly average figured in B13 as I enter each month. *So... I
want to enter January Figure in B1, February Figure in B2 and have the
Average in B13. *Then I want to add March Figure in B3 and have the average
of the first three in B13 and so on and so on so I can compare Monthly
Averages this year with a total monthly average from Last year in column B14.
*I have no idea how to do this. *Any help is appreciated!

Thanks to all,
--
Sam

Excel Formulas
 

This worked perfectly, thank you Pete_UK for your help!!
--
Sam


"Pete_UK" wrote:

Put this in B13:

=AVERAGE(B1:B12)

It will ignore blank cells, so as you add numbers into B1:B12 it will
give you their average.

If all the cells are empty it will return the #DIV/0 error, but you
can avoid that with this:

=IF(COUNT(B1:B12)=0,"",AVERAGE(B1:B12))

Hope this helps.

Pete

On Jan 21, 5:16 pm, Sam wrote:
I want to create a formula in cell B13 that will add up cells B1 thru B12 and
give me an average in B13. However, B1 thru B12 represent each month and I
want a running monthly average figured in B13 as I enter each month. So... I
want to enter January Figure in B1, February Figure in B2 and have the
Average in B13. Then I want to add March Figure in B3 and have the average
of the first three in B13 and so on and so on so I can compare Monthly
Averages this year with a total monthly average from Last year in column B14.
I have no idea how to do this. Any help is appreciated!

Thanks to all,
--
Sam

Excel Formulas
 

B13 would be:
=AVERAGE(B1:B12)
Unless I am misunderstanding your question.


"Sam" wrote:

I want to create a formula in cell B13 that will add up cells B1 thru B12 and
give me an average in B13. However, B1 thru B12 represent each month and I
want a running monthly average figured in B13 as I enter each month. So... I
want to enter January Figure in B1, February Figure in B2 and have the
Average in B13. Then I want to add March Figure in B3 and have the average
of the first three in B13 and so on and so on so I can compare Monthly
Averages this year with a total monthly average from Last year in column B14.
I have no idea how to do this. Any help is appreciated!

Thanks to all,
--
Sam

Excel Formulas
 

You're welcome, Sam - thanks for feeding back.

Pete

On Jan 21, 6:03*pm, Sam wrote:
This worked perfectly, thank you Pete_UK for your help!!
--
Sam