software

I'm a liitle confused about the difference between quot;regularquot; formulas and
array formulas. For example, I'm using quot;SUMPRODUCTquot; with 2 criteria to sum
values.

I am getting the correct sum, even though I don't have the array brackets in
my formula. Any help would be useful!gt; I am getting the correct sum, even though
gt; I don't have the array brackets in my formula.

SUMPRODUCT doesn't need to be array-entered, that's why lt;ggt;. And that's one
of its strengths !

(Think there could be exceptions though, for eg: where TRANSPOSE is used
within the SUMPRODUCT)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Davequot; gt; wrote in message
...
gt; I'm a liitle confused about the difference between quot;regularquot; formulas and
gt; array formulas. For example, I'm using quot;SUMPRODUCTquot; with 2 criteria to
sum
gt; values.
gt;
gt; I am getting the correct sum, even though I don't have the array brackets
in
gt; my formula. Any help would be useful!
gt;
Dave,

SUMPRODUCT works with array already, and doesn't need to be
array-entered. The array handling ability is built-in to
SUMPRODUCT natively.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Davequot; gt; wrote in message
...
gt; I'm a liitle confused about the difference between quot;regularquot;
gt; formulas and
gt; array formulas. For example, I'm using quot;SUMPRODUCTquot; with 2
gt; criteria to sum
gt; values.
gt;
gt; I am getting the correct sum, even though I don't have the
gt; array brackets in
gt; my formula. Any help would be useful!
gt;