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

You would add another column titled "Bulletins Used", calculated with:
=c2-b2

Then average column D, as in:
=average(d2:d4)

Regards,
Fred

"wiersma7" <(E-Mail Removed)> wrote in message
news:u$(E-Mail Removed)...
> 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" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
news:u$(E-Mail Removed)...
> 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