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...