Re: Sumproduct(N and --

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Everything you always wanted to know about Sumproduct but didn't know where
to look:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Biff

"BobS" <rstemper@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:OQBkOGg$GHA.4496@xxxxxxxxxxxxxxxxxxxxxxx
I use array formula quit often and was wondering if someone could please
explain the use of sumproduct(N and sumproduct(-- versus just sumproduct(.
I've seen the N and -- quit a bit in newsgroup responses, but am not clear
on their function. Thanks.




.