What I am trying to do is actually very simple, even because I've already found a way to do it, although it is too long and takes to much work to do. maybe you guys can figure out a simpler way to do it.
1. The result cells are supposed to be the sum of the product of two cells.
2. The long formula I made to get what I wanted was:
*As you can see, I made it from bottom to top, sorry.![]()
=SUM(E44*G44, E43*G43, E42*G42, E41*G41, E40*G40, E39*G39, E38*G38, E37*G37, E36*G36, E35*G35, E34*G34, E33*G33, E32*G32, E31*G31, E30*G30, E29*G29, E28*G28, E27*G27, E26*G26, E25*G25, E24*G24, E23*G23, E22*G22, E21*G21, E20*G20, E19*G19, E18*G18, E17*G17, E16*G16, E15*G15, E14*G14, E13*G13, E12*G12, E11*G11, E10*G10, E9*G9, E8*G8, E7*G7, E6*G6, E5*H5)
3. I have to do the same thing for other columns (the sum of the products of the values in each row of Col D and G and also Col C and G, and I don't want to click in every single cell and type * and , over and over again.
Please check:
Pedido de Material.xlsx
Bookmarks