sum by with function and iserror

krpatel · Mar 18th 2017

in sheet1 sum for the Range C2:C15 will be made by "With & End Function" by vba alongwith iserror or iferror function.

**Carim** · Mar 18th 2017

Re: sum by with function and iserror

Hello,

Is you new question related to your previous post :

Why are you not continuing the initial thread ...???

krpatel · Mar 18th 2017

Re: sum by with function and iserror

what is wrong in my formula suf iferror

.Formula = "= iferror (SUM (if(G19:G28 =0,"",G19:G28))"

**Carim** · Mar 18th 2017

Re: sum by with function and iserror

You can test following code

Code

Sub Test()
Range("B10").Formula = "=IF(SUM(G19:G28)=0,"""",SUM(G19:G28))"
End Sub

HTH

krpatel · Mar 18th 2017

Re: sum by with function and iserror

sir nice answer
thanks a lot

**Carim** · Mar 18th 2017

Re: sum by with function and iserror

Quote from krpatel;788374

sir nice answer
thanks a lot

Thanks ... for your thanks

Participate now!