Summing every 12 rows

  • Thread starter Thread starter Vincent Lee
  • Start date Start date
V

Vincent Lee

I've got 180 rows (these are months). I want to sume
every 12 rows and make rows that has this sum to
represent a year...how would I do that?
 
Hi Vincent,

Do you mean every 12th row

=SUMPRODUCT(--(A1:A100)*(MOD(ROW(A1:A100), 12)=0))

or 1-12 for Jan, 13-24 for Feb, then

=SUMPRODUCT((A1:A180)*(ROW(A1:A180)>(MONTH(I1)-1)*12)*(ROW(A1:A180)<=(MONTH(
I1)*12)))

where I1 holds a date for the month to be totalled

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
assume data in column a starting in row 1

in row 1 put in
=IF(MOD(ROW(),12)=0,SUM(OFFSET(A1,-11,0,12,1)),"")

drag fill down the column.
 
Back
Top