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
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="E")>0))
Regards
Chandra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
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-macros@googlegroups.com
Objet : $$Excel-Macros$$ Sumproduct using VBA
Hello,
Could you please let me know whats the error in
Hello,
Could you please let me know whats the error in using sumproduct function in
below code. I am getting error number 2015
Is there any other way to use sumproduct function using vba with multiple
condtions.
Thanks in advance.
Sub ABNAMROAdd()
Dim compnm As String
lastcl = ThisWorkbook.Work