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