Hi Kuldeep..
It Doesnt work.. can you show or attach file with solution.
Rgds
On Wednesday, September 12, 2012 10:40:39 PM UTC+5:30, Kuldeep Singh wrote:
>
>
> Hi,
>
> Try this.
>
> Function Udf_sum(rng As Excel.Range)
> Dim cell As Range
> For Each cell In rng
> If VBA.IsNumeric(cell) And cell.
Hi,
Try this.
Function Udf_sum(rng As Excel.Range)
Dim cell As Range
For Each cell In rng
If VBA.IsNumeric(cell) And cell.Value <> "" Then
Udf_sum = Udf_sum + cell
End If
Next cell
End Function* *
Regards,
Kuldeep Singh
On Wed, Sep 12, 2012 at 10:27 PM, Rajan_Verma wrote:
> * *
>
> * *
>
> *=S
=SUM(OFFSET($A4,,ROWS($L$3:L3),1,4))
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vabz
Sent: 12 September 2012 9:52
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: UDF to sum
IN J4 TYPE = SUM(OFFSET(A4,0,ROW(A1),1,4))
On Wed, Sep 12, 2012 at 9:52 PM, Vabz wrote:
> hi
>
> Question was really tuff..but not impossible..
>
> I could manage to solve without UDF
>
> PFA.. Soln is in K column..
>
> Cheerz..
>
> Rgds//Vabz
>
>
> On Friday, August 17, 2012 11:28:51 AM UTC+5
