Sumproduct

Question

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

for example

percentage0.040.080.20.181Amount 13467788954Amount 26798765432

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 Answer

Here is one way to do it:

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

caltang · Accepted Answer

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 Answer

@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.

binu_acs · Accepted Answer

@Navyasree123 Another option using batch macro