Thanks Sean....I see what you are doing here...
I even found an error on my part...my date is listed in Column AI, not
F....so I changed my formula to the following:

=SUMPRODUCT(--('Transit and PINPAD
Listing'!AI4:AI1047)=DATE(2009,9,1),--('Transit and PINPAD
Listing'!AI4:AI1047)<=DATE(2009,9,30),--('Transit and PINPAD
Listing'!Z4:Z1047="Installed"),--('Transit and PINPAD Listing'!L4:L1047))

However, this yields a value of 0....I know that this is not the case....

What else can i check....






"Sean Timmons" wrote:

=SUMPRODUCT(--('Transit and PINPAD
Listing'!F4:F1047)=DATE(2009,9,1),--('Transit and PINPAD
Listing'!F4:F1047)<=DATE(2009,9,30), --('Transit
and PINPAD Listing'!Z4:Z1047="Installed"), --('Transit and PINPAD
Listing'!L4:L1047))

"Princess V" wrote:

I am working on an excel spreadsheet to put together a report by using values
on our master worksheet.

The following information is what I am trying to use:

Column AI - contains date values in MM/DD/YY format.
Column Z - contains a status (Complete, Installed etc are potential values)
Column L - contains the numerical value of the units I want to sum.

I want to know What the total number of units that are Installed in
September 09 is....

here is what I am trying, but its not working!

=SUMPRODUCT(--(MONTH('Transit and PINPAD Listing'!F4:F1047)=9), --('Transit
and PINPAD Listing'!Z4:Z1047="Installed"), --('Transit and PINPAD
Listing'!L4:L1047))


I need to have the blanks ignored.....

HELP!