Not sure whether this is more of an Excel Forum issue, but I am having trouble with my table not automatically totalling the amounts when the data has been added via Power Automate. Has anybody experienced similar and know how to fix it?
Thanks

Not sure whether this is more of an Excel Forum issue, but I am having trouble with my table not automatically totalling the amounts when the data has been added via Power Automate. Has anybody experienced similar and know how to fix it?
Thanks
I have added the Formula =SUM(E:E) to generate the sum in E2. I thought to use (E:E) rather than (E3:E100) to avoid any issues with the new rows being added, but still no luck. Any help greatly appreciated.