How to calculate the value

[sjpras]

Hi Excel Guru,
I am looking for the VBA code to appear in cell A14. Formula is Sumif

Thanks

[YasserKhalil]

What about

Please Login or Register  to view this content.

[sjpras]

Hi Yaseer
Thanks for the formula. It works. But please see my new attachment. I have a formula in column C to replicate the duplicates in column B. In this case wheni apply the below formula result coming as error instead of 30.

Sub Test()

Dim CloseUP As Integer

CloseUP = Range.Formula = "=SUMIF(C2:C13,C1,B2:B13)"
Range("B15").Value = CloseUP
End Sub

Appreciate your help

[YasserKhalil]

If you need to get the value of the formula use that code

Please Login or Register  to view this content.

[sjpras]

Thanks It works

[YasserKhalil]

You're welcome. Glad I can offer some help for you