You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
<David Williamson wrote in message
...
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