I am wanting to fill a series with 5 columns to a single cell on another sheet.
Want it like this =sum(A1:E10) next cell. =sum(F1:J10).
When I drag fill handle it comes up =sum(A1:E10) next cell =sum(B1:F10) etc
Can tou help