thks
could you pls click YES if any of the posts were helpful?
;-)


On 14 Mar, 11:19, Sasikiran
wrote:
Thanks a ton Mike and Jarek...

Really appreciate your suggestions to make my job easier... :)

Continue to thrill all the users in the same way.

Thanks once again...



"Jarek Kujawa" wrote:
;-)))

On 14 Mar, 10:37, Mike H wrote:
Simply change the last 4 to a 5

=SUM(OFFSET(B$14,(ROW(1:1)-1)*48,,5))

Mike

"Sasikiran" wrote:
Dear Mike,

Sorry for the typo error...
You got that right thing what I'm trying to explain... but the below formula
is not working :(

=SUM(OFFSET(B$14,(ROW(1:1)-1)*48,,4))

Everytime I drag the formula down, it should refer to the 48th cell (B14+48
-- B62) and should calculate range of 5 continuos cells.

SUM(B14:B18) = 5 Cells
Â* Â* Â* Â* +48 +48
SUM(B62:B66) Â*= 5 cells
Â* Â* Â* Â* +48 +48
SUM(B110:B114) = 5 Cells
Â* Â* Â* Â* +48 +48
And so on....

"Mike H" wrote:

Hi,

The example you gives is confusing

SUM(B14:B18) = 5 Cells
SUM(B62:B68) Â*= 7 cells
SUM(B110:B114) = 5 Cells

Compared to what you ask for

it should calculate the sum range of 4 continuos cells after every 48th
cell...

So I'll guess and sum 4 cells every 48 cells, try this and drag down

=SUM(OFFSET(B$14,(ROW(1:1)-1)*48,,4))

Mike

"Sasikiran" wrote:

Dear,

I need to drag the formula in a column in such a way that the formula should
proceed in this manner.

SUM(B14:B18)
SUM(B62:B68) Â* Â* Â* Â*
SUM(B110:B114)

it should calculate the sum range of 4 continuos cells after every 48th
cell...

Hope this is clear

Please suggest- Ukryj cytowany tekst -

- Pokaż cytowany tekst -- Ukryj cytowany tekst -

- Pokaż cytowany tekst -