You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Princess V" wrote in message
...

This worked!!! Excellent!!!!!!!

Thank you so much!



"T. Valko" wrote:

What exactly isn't working?

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

The only time empty cells would be included is when you test for month 1
(Jan).

You can either include another array that tests for the year:

--(YEAR('Transit and PINPAD Listing'!F4:F1047)=2009)

Or, you can test for both month and year at the same time like this:

--(TEXT('Transit and PINPAD Listing'!F4:F1047,"m/yyyy")="1/2009")

What do think about this idea?

'Transit and PINPAD Listing' = T&PList

--
Biff
Microsoft Excel MVP


"Princess V" <Princess wrote in message
...
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!