Hey Chandra,
try this
Function xxx(x, y)
Dim a, b, c As Range
a = Range("a4:a14") ' contains text
b = Range("b4:b14") ' contains text
c = Range("c4:c14") ' contains values
Range("a20") = Application.SumProduct((a = x) * (b = y) * c)
End Function
On Tue, Aug 30, 2011 at 11:56 AM
Thank u very much got the solution.
Please let me know is there any other way to do this.
Thanks,
Chandra Shekar B
On Mon, Aug 29, 2011 at 5:49 PM, lifescholar wrote:
> On Aug 29, 3:36 pm, Chandra Shekar
> wrote:
> > Hello,
> >
> > Could you please let me know whats the error in using sumprod
