Forum Discussion

Jon-W's avatar
Jon-W
Copper Contributor
Jun 10, 2019

Sum If Then formula help

I need help with a formula, I think it's going to be a If Then sum formula, but I haven't had a lot of luck trying to figure this out on my own. In my example, I want to sum the payment amount (E), i...
Formulas and Functions
Jon-W's avatar
Jon-W
Copper Contributor
Jun 10, 2019

SergeiBaklan 

 

This is how I need to format it, this is how it looks when I just add it myself.

 

Kennesaw5/2/2019PROCONTRACTOR SUPPLY, INC.Master Card$855.00551905020002$855.00
Kennesaw5/3/20192019 CASH KENNESAWMaster Card$254.40551905030006$254.40
Kennesaw5/3/2019MAX JONESVisa$1,470.40551905030004$1,470.40
Kennesaw5/4/2019APEX SEAL COATINGSMaster Card$482.72551905040001$482.72
Kennesaw5/6/2019APEX SEAL COATINGSMaster Card$321.82551905060001$321.82
Kennesaw5/14/20192019 CASH KENNESAWVisa$281.59551905140007$281.59
Kennesaw5/15/20192019 CASH KENNESAWVisa 551905150006$58.29
Kennesaw5/15/20192019 CASH KENNESAWVisa$411.27551905150012$352.98
Kennesaw5/16/20192019 CASH KENNESAWVisa$136.21551905160005$136.21
Kennesaw5/23/20192019 CASH KENNESAWVisa$154.74551905230003$154.74
Kennesaw5/24/20192019 CASH KENNESAWVisa 551905240006$529.47
Kennesaw5/24/20192019 CASH KENNESAWVisa$618.50551905240007$89.03
Kennesaw5/28/20192019 CASH KENNESAWMaster Card$437.23551905280006$437.23
Kennesaw5/29/20192019 CASH KENNESAWMaster Card$335.23551905290002$335.23
Kennesaw5/29/20192019 CASH KENNESAWVisa$719.38551905290005$719.38
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 10, 2019

    Jon-W ,

     

    And do records sorted by dates in ascending order and when by card type? Or for the same date records could be like

    Visa

    MasterCard

    Visa

    MasterCard

     

     

    • Jon-W's avatar
      Jon-W
      Copper Contributor
      Jun 10, 2019

      SergeiBaklan 

       

      They are sorted first by date, then by card type.

Resources