Forum Discussion
smanas87
Apr 03, 2023Copper Contributor
Sum of Total Paid for each ID
Hello I'm trying to calculate Total paid amount 6m prior and 6m after initial based on the Paid, 6m prior to initial and 6m post initial columns. Please see below. Please advise a formula Tha...
- Apr 04, 2023
Done. See attached. The SUMIF function now does the totaling by ID.
I do recommend upgrading, however. There are quite a few new functions and capabilities in Excel, capabilities that are very exciting.
smanas87
Apr 04, 2023Copper Contributor
Hi mathetes Thank you for sharing I'm using Excel version 2016. Is it possible to modify? Please let me know thank you
mathetes
Apr 04, 2023Silver Contributor
Done. See attached. The SUMIF function now does the totaling by ID.
I do recommend upgrading, however. There are quite a few new functions and capabilities in Excel, capabilities that are very exciting.