Adding every 5th row (e.g. B5 + B10 + B15 etc)
 

Hi. Is there an easy way to do this without typing in every single cell
reference.

Thank you

Adding every 5th row (e.g. B5 + B10 + B15 etc)
 

I'd do it with a macro. Assign some variables and create a loop incrementing
by 5 each time. Take the value from the desired cell and add it to a
variable. When the range is completed, write the variable back to the
required cell in the s/s.

"Shazzer" wrote:

Hi. Is there an easy way to do this without typing in every single cell
reference.

Thank you

Adding every 5th row (e.g. B5 + B10 + B15 etc)
 

Let's say you have data from B1 thru B1000. In an un-used column, say column
Z enter:

=MAX(INT(ROW()/5)*5-ROW()+1,0) and copy down thru Z1000. Then
=SUMPRODUCT(B1:B1000,Z1:Z1000 will get what you want.)

--
Gary's Student


"Shazzer" wrote:

Hi. Is there an easy way to do this without typing in every single cell
reference.

Thank you

Adding every 5th row (e.g. B5 + B10 + B15 etc)
 

Hi Shazzer,

You could insert a helper column C, then in C5 put =B5,

Then highlight C1 to C5, grab the fill handle and drag down
as far as needed.

Then hide column C, and in whatever cell you wish put =SUM(C:C)

HTH
Martin

Adding every 5th row (e.g. B5 + B10 + B15 etc)
 

Try this:

=SUMPRODUCT((MOD(ROW(B1:B100),5)=0)*B1:B100)


--


HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Shazzer" wrote in message
...
Hi. Is there an easy way to do this without typing in every single cell
reference.

Thank you

Adding every 5th row (e.g. B5 + B10 + B15 etc)
 

Thank you all very much for your suggestions. I haven't decided which method
to use yet but they all seem reasonably straightforward. Thank you.

"Shazzer" wrote:

Hi. Is there an easy way to do this without typing in every single cell
reference.

Thank you

try this link for your basic formula
http://www.andrewsexceltips.com/menu...um_3rd_row.htm

happy holidays hohoho:)
driller2