array formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 17 Mar 2006 06:08 GMT

I'm a liitle confused about the difference between "regular" formulas and
array formulas. For example, I'm using "SUMPRODUCT" 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!

Reply to this Message

Max - 17 Mar 2006 06:44 GMT

> I am getting the correct sum, even though
> I don't have the array brackets in my formula.

SUMPRODUCT doesn't need to be array-entered, that's why <g>. And that's one
of its strengths !

(Think there could be exceptions though, for eg: where TRANSPOSE is used
within the SUMPRODUCT)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> I'm a liitle confused about the difference between "regular" formulas and
> array formulas. For example, I'm using "SUMPRODUCT" 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!

Reply to this Message

Chip Pearson - 17 Mar 2006 17:41 GMT

Dave,

SUMPRODUCT works with array already, and doesn't need to be
array-entered. The array handling ability is built-in to
SUMPRODUCT natively.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

> I'm a liitle confused about the difference between "regular"
> formulas and
[quoted text clipped - 5 lines]
> array brackets in
> my formula. Any help would be useful!

Reply to this Message