Re: SUMPRODUCT

Giganews Newsgroups
Subject: Re: SUMPRODUCT
Posted by:  Bondi (mbondor…@hotmail.com)
Date: 8 Jun 2006

Mark McDonough wrote:
> I see a lot of posts here to do with sumproduct and I know how it works
> (multiplying corresponding data in arrays and then summing the results) but
> what practical applications does it have.
>
> What situations would best be taken advantage of by using sumproduct?

Hi,

Have a look at this article about counting and summing in Excel:

http://www.microsoft.com/office/previous/xp/columns/column10.asp

Regards,
Bondi

Replies

None

In response to

SUMPRODUCT posted by Mark McDonough on Thu, 08 Jun 2006