Adding range of numbers to column

		Microsoft Office Forums > Microsoft Excel > Excel
Adding range of numbers to column

FAQ

Thread Tools

Display Modes

07-20-2017, 10:35 AM

xor

Windows 10 Adding range of numbers to column

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

(1) =94*726*727/2 or

(2) =94*726*AVERAGE(1, 726) or

(3) =94*SUM(ROW(1:726))

(3) is an array formula so hold down Ctrl and Shift before pressing Enter.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help identifying numbers within a 20s range	rebs2017	Excel	0	03-10-2017 02:34 PM
Footer for page numbers recently started showing a colored field when adding page numbers	thefonebug	Word	12	10-24-2016 05:18 AM
Date range mysteriously adding 4 years	akatz85	Excel	7	03-25-2014 12:36 PM
How to obtain maximum value of an excel column with a large range?	sirkay	Excel	4	02-23-2014 08:17 AM
Adding an amount to a min-max range	Nibbles	Excel	4	06-13-2013 08:05 AM

Other Forums: Access Forums

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