| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
array formula values
How to get values obtained by an array formula in a single cell separated by
commas or any other symbols? Can we sum up or count the values obtained by an array formula in a single cell? |
|
#2
|
|||
|
|||
|
The answer to your second question is yes. Simply wrap the array formula
witha SUM() function, and commit the entire formula with Ctrl-Shift-Enter "TUNGANA KURMA RAJU" wrote: How to get values obtained by an array formula in a single cell separated by commas or any other symbols? Can we sum up or count the values obtained by an array formula in a single cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formula w/ Multiple SumIf Criteria | Excel Worksheet Functions | |||
| referencing the value of a cell containing an array formula | Excel Worksheet Functions | |||
| problem with Array Formula | Excel Worksheet Functions | |||
| Why won't pasted values from a formula appear in a pivot table | Excel Discussion (Misc queries) | |||
| How To Use Cells Without Values in a Formula | Excel Worksheet Functions | |||
Linear Mode
