=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!