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
Solved! Go to Solution.
@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
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.
@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.
@Navyasree123 Another option using batch macro