Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulate all in one cell
how to sum an equation that subjected to array of number in one cell? Let
formula be "10-a" and the "a" required from 1 to 20, and all this to be done in one single cell, is it possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulate all in one cell
Hi,
I can't say as I understand your question but here is the formula you asked for: =SUM(10-ROW(A1:A20)) array entered. -- Thanks, Shane Devenshire "carrol" wrote: how to sum an equation that subjected to array of number in one cell? Let formula be "10-a" and the "a" required from 1 to 20, and all this to be done in one single cell, is it possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulate all in one cell
Try this:
=SUMPRODUCT(10-ROW(INDIRECT("1:20"))) -- Biff Microsoft Excel MVP "carrol" wrote in message ... how to sum an equation that subjected to array of number in one cell? Let formula be "10-a" and the "a" required from 1 to 20, and all this to be done in one single cell, is it possible? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulate all in one cell
Hi,
Try using =SUM(10-ROW(A1:A20)) entered as an array formula using Contol-Shift-Enter, instead of just Enter. Dave url:http://www.ureader.com/msg/104240746.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulate a cell to change color when above/below an amount? | Excel Worksheet Functions | |||
how to formulate this??? | Excel Discussion (Misc queries) | |||
time formulate | Excel Discussion (Misc queries) | |||
HOW DO I FORMULATE A CELL TO ROUND $5.82 TO $5.85 | Excel Discussion (Misc queries) | |||
Excel: how to formulate conditional cell references | Excel Worksheet Functions |