Does anyone know the function code for sumproduct?
I am making an add-in with some functions to make calculations in cells shorter and one of them at the moment is:
public function CofM(location, mass)
CofM = application.worksheetfunction.sumproduct(location, mass) / application.worksheetfunction.sum(mass)
end function
but with this method The errors all come out as "value" and it isn't very neat. I have the code for sum in 2007 power programming but need sumproduct as well to do this properly.
Thanks to whoever posts it
Regards
Leon
Bookmarks