RE: quarterly totals
- From: "John Mansfield" <JohnMansfield@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 25 Apr 2005 19:50:06 -0700
Devko,
Assume the months are in A1:A6 and the data is in B1:B6.
Jan 5
Feb 3
Mar 6
Apr 4
May 2
Jun 5
The formula for quarter 1 is
=AVERAGE(B1:B3)
The formula for quarter 2 is
=AVERAGE(B4:B6)
Quarters 3 and 4 follow the same logic.
----
Regards,
John Mansfield
http://www.pdbook.com
"Davko" wrote:
> How would i write the formula for entering 4 separte quarterly totals into a
> bar graph. Thanks
>
.
- References:
- quarterly totals
- From: Davko
- quarterly totals
- Prev by Date: RE: How do I combine two different charts?
- Next by Date: Re: waterfall chart ... once again ...
- Previous by thread: quarterly totals
- Next by thread: How could insert symbols e.g. micro in chart legend in Excel?
- Index(es):
Relevant Pages
|
