Thanks for clarifying that. I was under the impression that all array
formulas had to be entered with Ctrl-shift-enter.

Alok Joshi

"JE McGimpsey" wrote:

> Well, it is an array-formula, but it doesn't need to be entered with
> CTRL-SHIFT-ENTER.
>
> In article <F57AB7F8-CC93-49DE-B6DE-84163BAD1BAD@microsoft.com>,
> "Alok" <Alok@discussions.microsoft.com> wrote:
>
> > The formula is as follows
> >
> > =SUMPRODUCT(--(F3:F326="2-Color"),--(L3:L326="4"),--(N3:N326="1"),M3:M326)
> >
> > Please note that this is an array formula and has to be entered with
> > Control-Shift-Enter.
>