Add every third cell

  • Thread starter Thread starter FrankB
  • Start date Start date
F

FrankB

I have three columns for each month of the year. Is there
a way to sum up the year to date without having to
manually put in the cell references. Example:

CELL A1 CELL A2 CELLA3 CELL A4 CELL A5
5 10 15 20 25
CELLA6
30



Sum(A1+a4) etc for the whole year

Thanks
Frank
 
See if this array formula works. Since it is an array formula must use
control+shift+enter.

=SUM((MOD(ROW($H1:$H9),3)=MOD(ROW($H1),3))*$H1:$H9)
 
The other thing you can try, and I am assuming here that if you have 3 columns for each month,
that you are using something like Forecast / Budget / Actuals, or something similar, with those
titles being at the top of each column, is SUMIF, eg

=SUMIF(B$2:Y$2,"Budget",B4:Y4)

This will take a look at the titles in Row 2, and for every column that the title is Budget, it
will add up the values in Row 4.

The $ signs fix the reference on Row 2 for the titles, so that you could copy the ofrmula down the
page if you wanted to sum say Rows 3,4,5,6,7 etc
 
Back
Top