In addition, Chip Pearson has a nice explanation of how basic array formulas
work. See:

http://www.cpearson.com/excel/array.htm

HTH
Jason
Atlanta, GA

"LA" wrote:

some formulae just only work if entered in the form of array formular (Ctrl +
Shift + Enter). Could you pls tell me how excel calculates in the form of
array formular or provide me with any source explainning this.
Any help would be much appreciated.
LA