software

I have many years of by month data listed in columns. I would like to
start a new sheet that adds 3 months of data into a quarterly column.
That is it would add the the first 3 months of a year for Q1, then take
months 4,5,6, for Quarter 2, months 7,8,9 for Q3 etc. and be able to
move the data to the new sheet automaticaly. Any ideas much
appreciated.
Thanks
Jake--
jgorman
------------------------------------------------------------------------
jgorman's Profile: www.excelforum.com/member.php...oamp;userid=33081
View this thread: www.excelforum.com/showthread...hreadid=528933Hi,
For results as tabulated below on Sheet2:

YearQ1Q2Q3Q4
200515866213189
2006155209167143
2007163000

Source has dates in column A and data in Column C on Sheet1. Change
ranges/sheets to suit.

In cell for Q1:

=SUMPRODUCT(--(MONTH(Sheet1!$A$1:$A$100)gt;=1),--(MONTH(Sheet1!$A$1:$A$100)lt;=3),--(YEAR(Sheet1!$A$1:$A$100)=$A2),--(Sheet1!$C$1:$C$100))

or

=SUMPRODUCT--(MONTH(Sheet1!$A$1:$A$100)lt;=3),--(YEAR(Sheet1!$A$1:$A$100)=$A2),--(Sheet1!$C$1:$C$100))

In Cell for Q2:

=SUMPRODUCT(--(MONTH(Sheet1!$A$1:$A$100)gt;=4),--(MONTH(Sheet1!$A$1:$A$100)lt;=6),--(YEAR(Sheet1!$A$1:$A$100)=$A2),--(Sheet1!$C$1:$C$100))In Cell for Q3:

=SUMPRODUCT(--(MONTH(Sheet1!$A$1:$A$100)gt;=7),--(MONTH(Sheet1!$A$1:$A$100)lt;=9),--(YEAR(Sheet1!$A$1:$A$100)=$A2),--(Sheet1!$C$1:$C$100))In Cell for Q4:

=SUMPRODUCT(--(MONTH(Sheet1!$A$1:$A$100)gt;=10),--(YEAR(Sheet1!$A$1:$A$100)=$A2),--(Sheet1!$C$1:$C$100))

Copy down.

HTHquot;jgormanquot; wrote:

gt;
gt; I have many years of by month data listed in columns. I would like to
gt; start a new sheet that adds 3 months of data into a quarterly column.
gt; That is it would add the the first 3 months of a year for Q1, then take
gt; months 4,5,6, for Quarter 2, months 7,8,9 for Q3 etc. and be able to
gt; move the data to the new sheet automaticaly. Any ideas much
gt; appreciated.
gt; Thanks
gt; Jake
gt;
gt;
gt; --
gt; jgorman
gt; ------------------------------------------------------------------------
gt; jgorman's Profile: www.excelforum.com/member.php...oamp;userid=33081
gt; View this thread: www.excelforum.com/showthread...hreadid=528933
gt;
gt;