Forum Discussion
Sum Calculation from List A to List B
Hi All,
Can anyone guide me on how to get the sum of Quantity for all quarters based on the product?
1] List A has complete data
2] List B has to be SUM of each fruit by quarterly.
Attached is the expected output data which I created in excel
Basically is used SUMIFS in excel.
Regards,
Vinod
1 Reply
vinodrocks300 so why not just click on Export to Excel at the top of List A and do the quarterly totals there? Otherwise you are going to have a complex flow in Power Automate to handle the calculations. Sometimes -perhaps surprisngly - Excel is the right solution.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
