Array formulas can be faster in that they can allow you to avoid
repeating a calculation that is shared by several cells.

Array formulas can also allow you to perform complicated calculations
without using helper cells.

If my previous formula is not what you are looking for, then your
explanation of what you are trying to do is not adequate for me to
understand your intent sufficiently to suggest a formula.

Jerry

Rob Gould wrote:

Thanks, but it's not that simple. The example I used was to give the
answer 60 - I see now that it appears that the 60 should be part of the
formula - sorry.. In my actual data, I have more than just 4 columns
and I want to be able to add more if need be. Yes, I could just
multiply and add as you have done in the bracketed section of your
formula, but I thought that arrays were meant to do that quicker (or at
least in a shorter formula).


Jerry W. Lewis wrote:

=60-(A1*B1+C1*D1)

If you are putting these formulas in E, it is not clear why you would


need either array or sumproduct formulas.

Jerry

Rob Gould wrote:


Hi all. Let's say that I have 10 columns and a row for each day of

the

month. All odd columns contain a Dollar value and all even columns
contain a quantity. How can I multiply each Dollar amount by its
quantity and sum these for each day? An Array or sumproduct?

Example:
A1 = $2
B1 = 5
C1 = $5
D1 = 10

Answer in E1 must be 60 - (2*5 + 5*10)

Thanks.

Rob