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" wrote in message
...
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.