hi
To insert sumproduct formula thru VBA you by using evaluate.
Pl refer http://www.xldynamic.com/source/xld.SUMPRODUCT.html
HTH//Cheers
On Fri, Jul 12, 2013 at 7:17 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi,
>
> Could you please let me know how to use sumproduct using VB
Hi,
Could you please let me know what your are asking for?
Thanks in advance.
Regards,
Chandra
On Sat, Jul 13, 2013 at 7:23 AM, Bé Trần Văn wrote:
> With VBA require you to download the file
>
> 2013/7/12 Chandra Shekar
>
>> Hi,
>>
>> Could you please let me know how to use sumproduct using
With VBA require you to download the file
2013/7/12 Chandra Shekar
> Hi,
>
> Could you please let me know how to use sumproduct using VBA? Where range
> is date values.
>
>
> =SUMPRODUCT(--(INT(Dump!$F$2:$F$5)>=C2)*(INT(Dump!$F$2:$F$5)<=D2)*--((Dump!$D$2:$D$5="U")+(Dump!$D$2:$D$5
Hello,
Use :
a = "SUMPRODUCT(--(" & rng1 & "=""" & "BEL" & """),--(" & rng2 & "=""" &
"AAO" & """),--(" & rng4 & "))"
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Chandra Shekar
Envoyé : lundi 29 août 2011 16:37
À : excel-mac
