Forum Discussion

smanas87's avatar
smanas87
Copper Contributor
Apr 03, 2023

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...
  • 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.

Resources