I have office 2003 and need to learn how to create an Excel formula that will - add multiple cells, one cell in every 6th row (6, 12, 18, 24) of a column (column E) that is 6,744 rows deep? Please direct me how to do this.
I have office 2003 and need to learn how to create an Excel formula that will - add multiple cells, one cell in every 6th row (6, 12, 18, 24) of a column (column E) that is 6,744 rows deep? Please direct me how to do this.
=sumproduct(--(mod(row(a6:a6750),6)=0),a6:a6750)
Last edited by martindwilson; 11-12-2013 at 09:57 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Ok, the way I would try it would be to create a helper column where rows 1 through 6 would have something distinct like a, b, c, d, e, f, then repeat. Once excel recognizes the repitition just double click on it and it will autopopulate to the bottom. Then I would do a sumif stmt like...
=SUMIF(B2:B6760,"f",A2:A6760) and it will give you the sum.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Just changed the smproduct it had a typo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks