Thread: Average Formula

I'm trying to find the average of bulletins used each Sunday. I'm keeping
track of how many I produce each Sunday and how many are left.

Basic table...

Week Bulletin Amt. Bulletins left
Week 1 100 34
Week 2 100 17
Week 3 110 20

I'm keeping track for the year (52 weeks)

What kind of formula would I use?

Thanks, wiersma7

"wiersma7" <office@parkwoodchurch.com> wrote:
> I'm trying to find the average of bulletins used each
> Sunday. I'm keeping track of how many I produce each
> Sunday and how many are left.

Try the following array formula[*]:

=AVERAGE(B2:B53-C2:C53)

where B2:B53 contains "bulletin amt" and C2:C53 contains "bulletins left".
[*] Enter an array formula by pressing ctrl+shift+Enter instead of just
Enter. You should curly braces around the formula in the Formula Bar, i.e.
{=formula}. Note that you cannot type the curly braces yourself; Excel
displays them to denote an array formula. If you make a mistake, select the
cell, press F2, edit as needed, then press ctrl+shift+Enter.


----- original message -----

"wiersma7" <office@parkwoodchurch.com> wrote in message
news:u$pye26vKHA.1692@TK2MSFTNGP04.phx.gbl...
> I'm trying to find the average of bulletins used each Sunday. I'm keeping
> track of how many I produce each Sunday and how many are left.
>
> Basic table...
>
> Week Bulletin Amt. Bulletins left
> Week 1 100 34
> Week 2 100 17
> Week 3 110 20
>
> I'm keeping track for the year (52 weeks)
>
> What kind of formula would I use?
>
> Thanks, wiersma7