Multiply two columns and Sum all the products

[jerexwat]

So I'm doing a portfolio analysis with 12 stocks
I have to write a VBA function to multiply each elements in the two columns 'BETA' and 'WEIGHT' to count the portfolio beta
Then, after multiplying, I have to SUM all the 12 output into one figure
How do I do this, without using Application.WorksheetFunction?
**basically how to do SUMPRODUCT without using worksheetfunction.sum
Please Help! )
Best Regards, jerexwat

 

[vletm]

jerexwat
You should send a sample Excel -file,
with sample data
as well as
with expected results.

Of course, You've read above from New Users - Please Start Here

 

[jerexwat]

jerexwat
You should send a sample Excel -file,
with sample data
as well as
with expected results.

Of course, You've read above from New Users - Please Start Here

Right of course
I need a VBA function, not a Macro(sub).. so yeah
any help would be highly appreciated thank you