5000 rows, want to select and perform addition on ever 48 rows

		Microsoft Office Forums > Microsoft Excel > Excel
5000 rows, want to select and perform addition on ever 48 rows

FAQ

Mark Forums Read

Thread Tools

Display Modes

06-09-2019, 10:09 PM

Rexmaverick Rexmaverick is offline

Windows 10 5000 rows, want to select and perform addition on ever 48 rows

Office 2016

Novice

Join Date: Jun 2019

Posts: 3

5000 rows, want to select and perform addition on ever 48 rows

Hi,

Thank you for having a look, I have done this years ago and cannot remember how to achieve it again,

As above I have approx 5000 rows, I wand to select O2:048 and put result in p48, then select O49:O97 and put result in P97, then O98:O145 and put result in P145.

Appreciate any assistance

Rex

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need to apply Heading1 to select rows	bobk544	Word VBA	3	06-09-2018 05:24 AM
How to find duplicate rows in a huge excel file containing 500000 rows	Stc25234	Excel Programming	2	06-23-2017 10:51 AM
Select rows w/cells containing given character strings, then sum cell in two other col.	LarryHills	Excel	1	02-17-2017 03:55 PM
Delete All empty Rows - Print - Undo all Rows deleted	Bathroth	Word VBA	1	10-01-2014 01:40 PM
Grouping table rows to prevent individual rows from breaking across pages	dennist77	Word	1	10-29-2013 11:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:34 AM.