Thank you very much worked perfectly. Best Regards Dave



T. Valko wrote:

Try this...
30-Mar-10

Try this...

=SUMPRODUCT(--(TEXT(L4:L21,"m/yyyy")="3/2010"),--(Q4:Q21<""),--(Q4:Q21=0),K4:K21)

Add your sheet name.

--
Biff
Microsoft Excel MVP

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Making Silverlight Emulate Synchronous Requests
http://www.eggheadcafe.com/tutorials...ht-emulat.aspx