What is the difference between a shared formula and an array formula?

Question

Excel defines shared formulas and array formulas. What is the difference? My understanding is that array formulas are now obsolete. Is this true? Is it possible to transform array formulas into shared formulas?

Answer 1

Look at section 4.8 of The Microsoft Excel File Format (PDF ref).

Answer 2

Shared formulas are simply a more efficient means of storing formulas.

Array formulas add significant functionality and are definitely not obsolete. For example, the MMULT function can return multiple values. To get these multiple values into multiple cells you must use an array formula. Array formulas are entered into a range of cells by selecting the range, typing the formula, and then pressing CTRL+SHIFT+ENTER.

Answer 3

I need to do the same thing with Visual Basic 6.0 and 6.0 FarPoint Spread

This is the code

. Formula = "SUM ((B" & Row & ": B" & Row2 - 1 & "=""" & Dolar & """)*( C "& Row &": C "& Row2 - 1 &" )) "

Dollar is the currency, I need you when it finds the coin will add up.

Excel is that looks something like

= SUM ((($ B $ 29: $ B $ 336) = "Dolar ")*($ C $ 29: $ C $ 336))

Thanks