Forum Discussion

smanas87's avatar
smanas87
Copper Contributor
Apr 03, 2023
Solved

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...
excel
  • mathetes's avatar
    mathetes
    Apr 04, 2023

    smanas87 

     

    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's avatar
smanas87
Copper Contributor
Apr 04, 2023
Hi mathetes Thank you for sharing I'm using Excel version 2016. Is it possible to modify? Please let me know thank you
mathetes's avatar
mathetes
Silver Contributor
Apr 04, 2023

smanas87 

 

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.

Resources