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.)