I have two columns (e.g. a1:a100 and b1:b100) filled numeric values and i need the sumproduct of the two columns of data, considering that it will only read or sum the value up to 2 decimal places of each product in every row....

can anyone help me out with this with a single formula.

any of your suggestion is requested.

thanks
romelsb :)