How do I fill a sum formula for for quarters into adjacent years

G

Guest

I want to take the sum formula for quarters for a year and fill it
horizontally for each additional year. However the cell refrences only moves
over one column, however I need it to move over 4 columns to sum correclty.
Is there an easier way to do this than going back and manually fixing the
refrence that sums up each quarter for a given year?
 
G

Guest

Try

=SUM(OFFSET($B$3,0,4*(COLUMN(A:A)-1),1,4))

Where B$3 is the cell with the 1st quarter of the 1st year
 

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

Similar Threads

How do I sum cashflows within date range given dates and cash flow 1
Subtotaling Quarters (and Years) from Months 4
Count number of cols which contain a value(s) in it less than x(array formula?) 1
How to do a rolling average on a query that asks for input 8
How to distribute/spread/map cost of project across different year 3
how can I start and stop a sum formula? 1
Conditional SUM for Budget, Actuals, & Variance YTD columns 0
looking for a formula please. 5

Top