Using SUMPRODUCT or an Array to calculate formulas with multiple criteria?

I have learned how to use both a sumproduct formula and an array formula to both "count" and "sum" based on multiple criteria.

However my question to all of you is, what advantage does an array have over sumproduct and vice versa.

Personally i don't see why you wouldn't use sumproduct in place of ANY array.

Thanks

Agreed. I try to use sumproduct when I can but some don't lend themselves to
that with a short formula such as average(if

--
Don Guillett
SalesAid Software
[email protected]
"jim_0068" <[email protected]> wrote in
message news:[email protected]...
>
> I have learned how to use both a sumproduct formula and an array formula
> to both "count" and "sum" based on multiple criteria.
>
> However my question to all of you is, what advantage does an array have
> over sumproduct and vice versa.
>
> Personally i don't see why you wouldn't use sumproduct in place of ANY
> array.
>
> Thanks
>
>
> --
> jim_0068
> ------------------------------------------------------------------------
> jim_0068's Profile:
> http://www.excelforum.com/member.php...o&userid=32822
> View this thread: http://www.excelforum.com/showthread...hreadid=551604
>

If you attend Charles Williams' presentation at the UK Excel User Conference
in July, you might find a reason for preferring one over another.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"jim_0068" <[email protected]> wrote in
message news:[email protected]...
>
> I have learned how to use both a sumproduct formula and an array formula
> to both "count" and "sum" based on multiple criteria.
>
> However my question to all of you is, what advantage does an array have
> over sumproduct and vice versa.
>
> Personally i don't see why you wouldn't use sumproduct in place of ANY
> array.
>
> Thanks
>
>
> --
> jim_0068
> ------------------------------------------------------------------------
> jim_0068's Profile:
http://www.excelforum.com/member.php...o&userid=32822
> View this thread: http://www.excelforum.com/showthread...hreadid=551604
>

Sorry, don't have the cash to fly over for an excel conference.

Do you have an opinion on the matter?

I tend to agree with Don, as they both work on arrays and suffer the
performance overhead therein. Array formulae, array functions, it has the
same calculation path AFAICS. But I look forward to hearing what Charles has
to say as he is an acknowledged expert on Excel calculation and performance.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"jim_0068" <[email protected]> wrote in
message news:[email protected]...
>
> Sorry, don't have the cash to fly over for an excel conference.
>
> Do you have an opinion on the matter?
>
>
> --
> jim_0068
> ------------------------------------------------------------------------
> jim_0068's Profile:
http://www.excelforum.com/member.php...o&userid=32822
> View this thread: http://www.excelforum.com/showthread...hreadid=551604
>

Hi

When the result will be a number, then I prefer SUMPRODUCT, unless array
formula is much shorter and looking more nice.
When the result will be a string ... there are no options left, as you see
:-))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


"jim_0068" <[email protected]> wrote in
message news:[email protected]...
>
> I have learned how to use both a sumproduct formula and an array formula
> to both "count" and "sum" based on multiple criteria.
>
> However my question to all of you is, what advantage does an array have
> over sumproduct and vice versa.
>
> Personally i don't see why you wouldn't use sumproduct in place of ANY
> array.
>
> Thanks
>
>
> --
> jim_0068
> ------------------------------------------------------------------------
> jim_0068's Profile:
> http://www.excelforum.com/member.php...o&userid=32822
> View this thread: http://www.excelforum.com/showthread...hreadid=551604
>