Sumproduct(N and --

From: "BobS" <rstemper@xxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 1 Nov 2006 16:03:06 -0600

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.

.

Follow-Ups:
- Re: Sumproduct(N and --
  - From: Harlan Grove
- Re: Sumproduct(N and --
  - From: Biff

Prev by Date: Re: Repeating an Excel Formula
Next by Date: Re: Find String in another string - only between spaces
Previous by thread: Re: Repeating an Excel Formula
Next by thread: Re: Sumproduct(N and --
Index(es):
- Date
- Thread