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 :)

Hi Romelsb,

I think this should work:

=SUMPRODUCT(ROUND(A1:A100,2),ROUND(B1:B100,2))
--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"driller2" wrote:


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 :)




--
driller2

thanks a lot, it works
i dont know yet how to rate your reply c/o this excelbanter webpage. Can u tell me how to place a checkmark here ?
:)

oopss, i got confused, when i view the decimal places of the result, it is more than 2....it seems this do not work out...hope we have another solution..:) thanks