Average Formula

[wiersma7]

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

 

[Fred Smith]

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

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

Regards,
Fred

 

[Joe User]

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 -----