Prev: VBA Macro help
Next: sum if one or another criteria
From: David on 31 Mar 2010 07:43
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/aspnet/91f69224-3da5-4959-9901-c5c717c9b184/making-silverlight-emulat.aspx
From: T. Valko on 31 Mar 2010 12:31
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


<David Williamson> wrote in message
news:201033174311dmwilliamson(a)btinternet.com...
> 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/aspnet/91f69224-3da5-4959-9901-c5c717c9b184/making-silverlight-emulat.aspx


 | 
Pages: 1
Prev: VBA Macro help
Next: sum if one or another criteria