Summing every 12 rows

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

Bob Phillips

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

Tom Ogilvy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top