a multi-rounded sumproduct

D

driller2

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

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

any of your suggestion is requested.

thanks
romelsb :
 
M

Martin Fishlock

Hi Romelsb,

I think this should work:

=SUMPRODUCT(ROUND(A1:A100,2),ROUND(B1:B100,2))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need sumproduct 5
SUMPRODUCT to substiute array formula 7
Sum total using Sumproduct if two criteria met 5
How to combine SUMPRODUCT with COUNTIF? 6
Macro that copies values from column A (from formula) to B (paste value) 1
SUMPRODUCT formaula not working 1
Sumproduct in matrix means 3
Help in counting and summing cells based on multiple conditions 9

Top