I often see these functions used together and used quite a lot but what
practical application do they have?

From reading the help files it is easy to understand the theory of what's
going on but applying it in practice is something else.

Sumproduct was a classic case in point here. Going by the help file, we are
told that sumproduct multiplies corresponding values in arrays and then sums
the result (yeah but so what). But who would have guessed from this that
it's application is quite extensive as a filtering tool of a sort.



----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----