Experts: I can't figure this out... I need to add another array to this
formula.

=SUMPRODUCT(--(A3:A236="John
Gay"),--(W3:W236>=--"2008-01-01"),--(W3:W236<=--"2008-12-31"))

In array #1 I am searched "column A" for the name John Gay. In arrays #2 &
#3 I am searching "column W" for entry's within a date range. My problem is
this:

I have another column (column Y) that has numerical entry's. This column
represents the quantity of products that John Gay sold on any given date
within the date range. Most of the entry's in "column Y" have a value larger
than 1.

How can I modify this formula to count the actual total of the numerical
values in "column Y" after array #1, #2 & #3 have been recognized as true or
false?

I hope I have explained my issue clearly... Anyones help would be greatly
appreciated. Thanks...

TRY THIS...

=SUMPRODUCT(--(A3:A236="John Gay"),--(W3:W236>=--"2008/01/01"),--
(W3:W236<=--"2008-12-31"),--(X3:X236<>""))


It assumes that the numerical value is in column . You can also change
it to total the numerical values by changing the --(X3:X236<>"") to
x3:x236

On Jun 20, 8:13 am, PBB <P...@discussions.microsoft.com> wrote:
> Experts: I can't figure this out... I need to add another array to this
> formula.
>
> =SUMPRODUCT(--(A3:A236="John
> Gay"),--(W3:W236>=--"2008-01-01"),--(W3:W236<=--"2008-12-31"))
>
> In array #1 I am searched "column A" for the name John Gay. In arrays #2 &
> #3 I am searching "column W" for entry's within a date range. My problem is
> this:
>
> I have another column (column Y) that has numerical entry's. This column
> represents the quantity of products that John Gay sold on any given date
> within the date range. Most of the entry's in "column Y" have a value larger
> than 1.
>
> How can I modify this formula to count the actual total of the numerical
> values in "column Y" after array #1, #2 & #3 have been recognized as true or
> false?
>
> I hope I have explained my issue clearly... Anyones help would be greatly
> appreciated. Thanks...

Thanks TIM879 - This worked great !!

"Tim879" wrote:

> TRY THIS...
>
> =SUMPRODUCT(--(A3:A236="John Gay"),--(W3:W236>=--"2008/01/01"),--
> (W3:W236<=--"2008-12-31"),--(X3:X236<>""))
>
>
> It assumes that the numerical value is in column . You can also change
> it to total the numerical values by changing the --(X3:X236<>"") to
> x3:x236
>
> On Jun 20, 8:13 am, PBB <P...@discussions.microsoft.com> wrote:
> > Experts: I can't figure this out... I need to add another array to this
> > formula.
> >
> > =SUMPRODUCT(--(A3:A236="John
> > Gay"),--(W3:W236>=--"2008-01-01"),--(W3:W236<=--"2008-12-31"))
> >
> > In array #1 I am searched "column A" for the name John Gay. In arrays #2 &
> > #3 I am searching "column W" for entry's within a date range. My problem is
> > this:
> >
> > I have another column (column Y) that has numerical entry's. This column
> > represents the quantity of products that John Gay sold on any given date
> > within the date range. Most of the entry's in "column Y" have a value larger
> > than 1.
> >
> > How can I modify this formula to count the actual total of the numerical
> > values in "column Y" after array #1, #2 & #3 have been recognized as true or
> > false?
> >
> > I hope I have explained my issue clearly... Anyones help would be greatly
> > appreciated. Thanks...
>
>