Sum of round numbers

Hello folks!
I have a problem with rounding and sums.

What I need is to:
1.Round product of two numbers on 2 decimals (I don't need more decimal places)
2.Then Sum all of these products on 2 decimals.

What I am guessing that probably Sum of these numbers is primary executed and then Product of those numbers is Rounded, because I'm getting wrong numbers.
I need first to round those numbers and then sum them.

Hope someone will help me.

Thanks!

Originally Posted by Domski

Hi,

Try:

=SUMPRODUCT(ROUND(A1:A10,2),ROUND(B1:B10,2))

Dom

Thank you for your help.
If I use this function you gave me I only receive empty cell
I tried some of solutions like this but it didn't worked (don't know what this empty cell means).

In my example I have 3 Sums
0.00400
0.00400
0.00400
rounded on 2 decimals it should be:
0.00
0.00
0.00
and Sum of these sums above should be
0.00
but I am getting the result
0.01

I assume that excel is first doing Sum of results then Round of each result.

Hoping this will explain my problem.
Thanks a lot!

I solve the problem.Formulas were right but problem was in formating made by my friend who asked for my help and who gave me a file
Dom, thanks a lot man!