array formula values

T

TUNGANA KURMA RAJU

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?
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ISODD array formula 1
randomly picking up an array element from an array of elements 2
Excel does not accept text format! 0
Using <= in countifs statement 1
need help in fine-tuning a formula that removes blank cells in a column range 3
Embedded Count If 1
array function vlookup 2
Formula to sum values extracted from string 10

Top