Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need sumproduct
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 each result up to 2 decimal places only ....
can anyone help me out with this with a single formula. e.g. [col A] [col B] [rounded product A*B] [$ 1.233 ] [ 33.222 ] [ $ 40.96 ] [$ 0.245 ] [ 11.111 ] [ $ 2.72 ] [$ 0.122 ] [ -3.215 ] [ $ -0.39 ] from the above sample the sum of the product (2 decimals) = $43.29 can anyone help me out with this using a single formula for my quick presentation. any of your suggestion is requested. thanks romelsb 4pinoy :) on banter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
Need help with sumproduct & dynamic ranges | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |