SUMPRODUCT in VBA

[gan_xl]

Hi,

I need to convert the below excel function in to VBA

Please Login or Register  to view this content.

I have tried the below code but it shows 'Application-defined or Object-defined error'

Please Login or Register  to view this content.

Kindly help me to get out of this.

Thanks

[zbor]

you can not SUM that way.

Try something like:

Please Login or Register  to view this content.

[ragulduy]

Please Login or Register  to view this content.

?

[gan_xl]

Thank you both. It works perfectly.