Adding range of numbers to column

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

FAQ

Mark Forums Read

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,103

(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 »

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 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 04:12 PM.