ExcelBanter - array formula values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - array formula values (https://www.excelbanter.com/excel-discussion-misc-queries/47840-array-formula-values.html)

TUNGANA KURMA RAJU

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?

Duke Carey

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?

All times are GMT +1. The time now is 06:15 AM.