Forum Discussion
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...
Jon-W ,
It depends on how you'd like organize the result. If like
then
=SUMIFS($G:$G,$D:$D,J$1,$B:$B,$I2)
This is how I need to format it, this is how it looks when I just add it myself.
Kennesaw 5/2/2019 PROCONTRACTOR SUPPLY, INC. Master Card $855.00 551905020002 $855.00 Kennesaw 5/3/2019 2019 CASH KENNESAW Master Card $254.40 551905030006 $254.40 Kennesaw 5/3/2019 MAX JONES Visa $1,470.40 551905030004 $1,470.40 Kennesaw 5/4/2019 APEX SEAL COATINGS Master Card $482.72 551905040001 $482.72 Kennesaw 5/6/2019 APEX SEAL COATINGS Master Card $321.82 551905060001 $321.82 Kennesaw 5/14/2019 2019 CASH KENNESAW Visa $281.59 551905140007 $281.59 Kennesaw 5/15/2019 2019 CASH KENNESAW Visa 551905150006 $58.29 Kennesaw 5/15/2019 2019 CASH KENNESAW Visa $411.27 551905150012 $352.98 Kennesaw 5/16/2019 2019 CASH KENNESAW Visa $136.21 551905160005 $136.21 Kennesaw 5/23/2019 2019 CASH KENNESAW Visa $154.74 551905230003 $154.74 Kennesaw 5/24/2019 2019 CASH KENNESAW Visa 551905240006 $529.47 Kennesaw 5/24/2019 2019 CASH KENNESAW Visa $618.50 551905240007 $89.03 Kennesaw 5/28/2019 2019 CASH KENNESAW Master Card $437.23 551905280006 $437.23 Kennesaw 5/29/2019 2019 CASH KENNESAW Master Card $335.23 551905290002 $335.23 Kennesaw 5/29/2019 2019 CASH KENNESAW Visa $719.38 551905290005 $719.38 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
