Hi Jerry,

Sorry - let me try and explain clearer...

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

This goes on until COL AJ (15 multiplications added together), which is
why I don't really want a formula that just multiplies and adds
i.e.(A1*B1+C1*D1) - although it will work. In other words, is there a
shorter, more clever formula to use that will do the job?

Rob



Jerry W. Lewis wrote:
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