Sum Calculation from List A to List B

Copper Contributor
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.




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. 


Los Gallardos
Microsoft Power Automate Community Super User