Sumifs multiple criteria with column

[achu]

Dear Expart,

I would like to thank you first,

i am trying to sumifs but not complet

my formula is :--
SUM(SUMIFS('[Vinit-Master Data.xlsx]Dump'!$L:$L,'[Vinit-Master Data.xlsx]Dump'!$A:$A,"Sold",'[Vinit-Master Data.xlsx]Dump'!$C:$C,"Orion-1",'[Vinit-Master Data.xlsx]Dump'!$J:$J,{"4 BHK",""}))ou

i want to convert this VBA Code,


kindly help me

again thank you...

 

[Naresh Yadav]

Can we have some part of your data in excel file?

 

[achu]

Please find attachd doc. as you requested

again thank you for your help advance...,

 

[Deepak]

Is this...

Sub sum1()
Dim str_f As String
str_f = "SUM(SUMIFS(Data!L:L,Data!A:A,""sold"",Data!C:C,Formula!C5,Data!J:J,{""4 BHK"";""""}))"

[d8] = Evaluate(str_f)

End Sub

 

[achu]

getting #Value

 

[Deepak]

I didn't.

Check this..

 

[achu]

Thank You sir,

it is correct...