=SUMPRODUCT(ROW(INDIRECT("1:"&A1)))
--
Regards,
Dave
"Scott" wrote:
> If I want to be able to input a number in a cell and in another cell take the
> sum of the number with all of the numbers smaller than it without a macro how
> would I do it?
>
> Example:
> If I put a 6 in a cell, I want another cell to output 21 (6+5+4+3+2+1)
>
> Thanks!
Dave that's FREAKIN AWESOME!!!!
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks