hello
target range = G10:G10000
i want to sum of range ("G10:G29") In cell ("T10") and next sum of ("G30:G49") in cell ("T30") and next sum of ("G50:G69") in cell ("T50")
i mean sum of 20 rows of column G, and after 20 rows of column T,
thanx
hello
target range = G10:G10000
i want to sum of range ("G10:G29") In cell ("T10") and next sum of ("G30:G49") in cell ("T30") and next sum of ("G50:G69") in cell ("T50")
i mean sum of 20 rows of column G, and after 20 rows of column T,
thanx
Write this in T1 and pull formula down:
Formula:Please Login or Register to view this content.
Works perfect
thanx a lot Mod zbor
will add u reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks