Sumproduct

[Navyasree123]

Hello all,Hope all are great, I have a query today

for example

percentage	0.04	0.08	0.2	0.18	1
Amount 1	34	67	78	89	54
Amount 2	67	98	76	54	32

I need to find Total =(0.04*34)+(0.08*67)+(0.2*78)+(0.18*89)+(1*54)

How to simulate this

Thank you

[caltang · Accepted solution]

Here is one way to do it:

If this helps, kindly mark my comment as the accepted solution. Thanks!

[Navyasree123]

@caltang =SUMPRODUCT($N$6:$T$6,N8:T8) This formula i need to stimulate

N6 to T6 Range is percentages

Remaining is N8 to T8 like N9 to T9 and N10 to T10

[caltang · Accepted solution]

Have you tried the workflow yet? 

Please try it yourself first and see what you get. In addition, a PNG is not useful unless it comes with sample data.

[rohityaman · Accepted solution]

@Navyasree123I think what you need is to leverage the multi field formula tool to select as many rows from the source and multiply each of them with the same % values.

I'm attaching one solution here. See if that works for you.

[binuacs · Accepted solution]

@Navyasree123 Another option using batch macro