Thread
:
Adding range of numbers to column
View Single Post
07-20-2017, 10:35 AM
xor
Windows 10
Office 2016
Expert
Join Date: Oct 2015
Posts: 1,097
(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.
xor
View Public Profile
Find all posts by xor