Understanding the logic and criteria of Array formulas

[Starguy]

Hi all

I want to understand the logic of array formulas that how they work. infact
I want to know the crieteria behind making the arrays.
I used some arrays and made some as well (like SUM IF array) but the main
thing which I want to know is the crieteria to make arrays and what Excel
functions we can use in arrays and what not? e.g I have seen mainly SUM and
IF functions which are used in arrays but many other functions do not work
when tried to used in arrays.
I have read many articles including microsoft's articles on array formula,
all article contain some formulas (basic and advanced) but the logic and
basic crieteria to make arrays is not explained.

can you please guide me to make the arrays (basic and with nested functions
as well.)

 

[Starguy]

Do Microsoft experts not have any explanation about the question I posted?

 

[MartinW]

Hi Starguy,

The people who reply to this newsgroup have nothing to
do with Microsoft. They are just everyday people like
you and me who have an interest (sometimes obsession)
in Excel.
Most of them come here to learn more and to help
others as they are doing it. Don't be dissappointed
by the lack of response to your post. It is very rare
for any question to be overlooked by everyone but
it does happen.
Take a look at this link and if you have further questions
Post again in a new thread. You may also want to do
a Google search for 'array formulas in excel'.
http://www.cpearson.com/excel/array.htm

HTH
Martin