wakwak1
01-13-2008, 05:12 PM
Maybe this can be done easier without VBA, but I have a column of numbers in B (some positive, some negative) and another column of numbers in F. I need to get the sumproduct of these two columns but firstly taking the abs value of numbers in B.
eg. in columnB we have 5, -5, 2, 2 and in column F we have 1,2,2,2
Then the result I need is 5*(1) + 5*2 + 2*2 + 2*2 = 23. So we are taking the abs value of numbers in B before doing the multiplication......ideas? Ta!
eg. in columnB we have 5, -5, 2, 2 and in column F we have 1,2,2,2
Then the result I need is 5*(1) + 5*2 + 2*2 + 2*2 = 23. So we are taking the abs value of numbers in B before doing the multiplication......ideas? Ta!