SUMPRODUCT

[Mark McDonough]

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?

 

[Bondi]

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